sys.sp_delete_jobserver

Description

Removes the specified target server. The identification number of the job from which the specified target server will be removed. must be specified, but both can’t be specified.

Syntax

sp_delete_jobserver
[ [ @job_id = ]
'job_id'
]
[ , [ @job_name = ]
N
'job_name'
]
, [ @server_name = ]
N
'server_name'
[ ; ]