Removes the specified target server.
- [ @job_id = ] job_id
The identification number of the job from which the specified target server will be removed. job_id is uniqueidentifier, with a default of NULL.
- [ @job_name = ] 'job_name'
The name of the job from which the specified target server will be removed. job_name is sysname, with a default of NULL.
Note: Either job_id or job_name must be specified; both cannot be specified.
- [ @server_name = ] 'server'
The name of the target server to remove from the specified job. server is nvarchar(30), with no default. server can be (LOCAL) or the name of a remote target server.
The following example removes the server
SEATTLE2 from processing the
Weekly Sales Backups job.
This example assumes that the |
USE msdb ; GO EXEC sp_delete_jobserver @job_name = N'Weekly Sales Backups', @server_name = N'SEATTLE2' ; GO