TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_delete_jobserver (Transact-SQL)

 

Applies To: SQL Server

Removes the specified target server.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions


sp_delete_jobserver { [ @job_id = ] job_id | [ @job_name = ] 'job_name' } , 
     [ @server_name = ] '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.

System_CAPS_ICON_note.jpg 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.

0 (success) or 1 (failure)

None

To run this stored procedure, users must be members of the sysadmin fixed server role.

The following example removes the server SEATTLE2 from processing the Weekly Sales Backupsjob.

System_CAPS_ICON_note.jpg Note


This example assumes that the Weekly Sales Backups job was created earlier.

USE msdb ;
GO

EXEC sp_delete_jobserver
    @job_name = N'Weekly Sales Backups',
    @server_name = N'SEATTLE2' ;
GO

sp_add_jobserver (Transact-SQL)
sp_help_jobserver (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft