sys.sp_add_jobserver

Description

Targets the specified job at the specified server. The identification number of the job. must be specified, but both can’t be specified. must be specified, but both can’t be specified.

Syntax

sp_add_jobserver
[ @job_id = ] job_id
| [ @job_name = ]
'job_name'
[ , [ @server_name = ]
'server'
]
[ ; ]