Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

Targets the specified job at the specified server.


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


[ @job_id = ] job_id

Is the identification number of the job. job_id is uniqueidentifier, with a default of NULL.

[ @job_name = ] 'job_name'

Is the name of the job. job_name is sysname, with a default of NULL.

Note  Either job_id or job_name must be specified, but both cannot be specified.

[ @server_name = ] 'server'

Is the name of the server at which to target the job. server is nvarchar(30), with a default of N'(LOCAL)'. server can be either (LOCAL) for a local server, or the name of an existing target server.

Return Code Values

0 (success) or 1 (failure)

Result Sets



@automatic_post exists in sp_add_jobserver, but is not listed under Arguments. @automatic_post is reserved for internal use.

SQL Server Enterprise Manager provides an easy, graphical way to manage jobs, and is the recommended way to create and manage the job infrastructure.


Execute permissions default to the public role for local jobs. Only members of the sysadmin fixed server role can execute sp_add_jobserver for multiserver jobs.


This example assigns the SEATTLE2 server to the multiserver job, Weekly Sales Data Backup job.

Note  This example assumes that the Weekly Sales Data Backup job already exists.

USE msdb
EXEC sp_add_jobserver @job_name = 'Weekly Sales Data Backup', 
   @server_name = 'SEATTLE2'

See Also



System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft