sys.sp_start_job

Description

Instructs SQL Server Agent to execute a job immediately. must be specified, but both can’t be specified. The identification number of the job to start. must be specified, but both can’t be specified. Identified for informational purposes only. Not supported.

Syntax

sp_start_job
[ [ @job_name = ]
N
'job_name'
]
[ , [ @job_id = ]
'job_id'
]
[ , [ @error_flag = ] error_flag ]
[ , [ @server_name = ]
N
'server_name'
]
[ , [ @step_name = ]
N
'step_name'
]
[ , [ @output_flag = ] output_flag ]
[ ; ]

Examples

Example 1

Weekly Sales Data Backup

Example 2

USE msdb;
GO
EXECUTE dbo.sp_start_job N
'Weekly Sales Data Backup'
;
GO