sp_start_job

Instructs the scheduler to execute a job immediately.

Syntax

sp_start_job 
    {   [@job_name    = ] 'job_name'
      | [@job_id      = ] job_id }
    [ , [@error_flag  = ] error_flag]
    [ , [@server_name = ] 'server_name']
    [ , [@step_name   = ] 'step_name']
    [ , [@output_flag = ] output_flag]

Arguments

[ @job_name = ] 'job_name'

The name of the job to start. Either job_id or job_name must be specified, but both cannot be specified. job_name is sysname, with a default of NULL.

[ @job_id = ] job_id

The identification number of the job to start. Either job_id or job_name must be specified, but both cannot be specified. job_id is uniqueidentifier, with a default of NULL.

[ @error_flag = ] error_flag

Identified for informational purposes only. Not supported.

[ @server_name = ] 'server_name'

The target server on which to start the job. server_name is nvarchar(128), with a default of NULL. server_name must be one of the target servers to which the job is currently targeted.

[ @step_name = ] 'step_name'

The name of the step at which to begin execution of the job. Applies only to local jobs. step_name is sysname, with a default of NULL

[ @output_flag = ] output_flag

Identified for informational purposes only. Not supported.

Result Sets

None

Permissions

By default, members of the sysadmin fixed server role can execute this stored procedure.

Members of sysadmin can start any job.

Examples

The following example starts a job named Weekly Sales Cache Rebuild.

EXEC dbo.sp_start_job N'Weekly Sales Cache Rebuild';

See Also