How to modify a master SQL Server Agent job (Transact-SQL)

To change the scheduling details for a job definition

• Execute sp_update_jobschedule.

To add, change, or remove steps from a job by working with the job steps

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.

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

See Also