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
- Execute sp_add_jobstep to add new job steps.
- Execute sp_update_jobstep to change pre-existing job steps.
- Execute sp_delete_jobstep to delete a pre-existing job.
To modify the target server(s) associated with a job
- Execute sp_delete_jobserver to delete a server currently associated with a job.
- 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
System Stored Procedures (SQL Server Agent Procedures)