Job management

Stored procedures for defining and controlling scheduler jobs, steps and schedules.

Stored procedure name	Description
sp_add_job	Adds a job executed by the job scheduler.
sp_add_jobstep	Adds a step (operation` to a job.
sp_add_schedule	Creates a schedule that can be used by any number of jobs.
sp_attach_schedule	Sets a schedule for a job.
sp_delete_job	Deletes a job.
sp_delete_jobstep	Deletes a step from the job.
sp_delete_schedule	Deletes a schedule.
sp_detach_schedule	Removes an association between a schedule and a job.
sp_help_job	Returns information about jobs.
sp_help_jobstep	Returns information for the steps in a job.
sp_start_job	Instructs the scheduler to execute a job immediately.
sp_update_job	Changes the attributes of a job.
sp_update_jobstep	Changes the setting for a step in a job that is used to perform automated activities.
sp_update_schedule	Changes the settings for a schedule.