Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
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 SQL Server Agent master job cannot be targeted at both local and remote servers.
See Also
Concepts
Other Resources
System Stored Procedures (Transact-SQL)
sp_add_job (Transact-SQL)
sp_add_jobstep (Transact-SQL)
sp_add_schedule (Transact-SQL)
sp_attach_schedule (Transact-SQL)
sp_add_jobserver (Transact-SQL)
sp_delete_jobserver (Transact-SQL)
sp_update_schedule (Transact-SQL)
sp_update_jobstep (Transact-SQL)
sp_delete_jobstep (Transact-SQL)