Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

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

To change the scheduling details for a job definition

  • Execute sp_update_schedule.

To add, change, or remove steps from a job

  1. Execute sp_add_jobstep to add new job steps.

  2. Execute sp_update_jobstep to change pre-existing job steps.

  3. Execute sp_delete_jobstep to delete a pre-existing job.

To modify the target server(s) associated with a job

  1. Execute sp_delete_jobserver to delete a server currently associated with a job.

  2. Execute sp_add_jobserver to associate a server with the current job.

NoteNote

A SQL Server Agent master job cannot be targeted at both local and remote servers.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.