Export (0) Print
Expand All
0 out of 6 rated this helpful - Rate this topic

How to: Create a SQL Server Agent Job (Transact-SQL)

This topic describes how to use stored procedures to create a Microsoft SQL Server Agent job.

To create a SQL Server Agent job

  1. Execute sp_add_job to create a job.

  2. Execute sp_add_jobstep to create one or more job steps.

  3. Execute sp_add_schedule to create a schedule.

  4. Execute sp_attach_schedule to attach a schedule to the job.

  5. Execute sp_add_jobserver to set the server for the job.

Local jobs are cached by the local SQL Server Agent. Therefore, any modifications implicitly force SQL Server Agent to re-cache the job. Because SQL Server Agent does not cache the job until sp_add_jobserver is called, it is more efficient to call sp_add_jobserver last.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.