Just a learner
Just a learner

Reputation: 28662

In the context of SQL server agent, what is a job server?

When you script a SQL agent job, there will be a sp_add_jobserver invocation in the script. I checked the documentation about this stored procedure but still can't understand what is a job server. As I understand, when you create a job, you are always create it on a specific server. Later you can run the job on that server. So why we need to use this stored procedure to combine a job to a server?

Upvotes: 3

Views: 2255

Answers (1)

wangguanguo
wangguanguo

Reputation: 181

To explan more details in here: To add a job to a different server,you must make a server the master server,and add target server(s) to it.After doing this,the SQL Server Agent in SSMS will become this:

SQL Server Agent MSX

The DelPDFHis job is target on another server: Job Properties of targets page

And the target server will download it to local. Target server Status

enter image description here

When executing the job in server a,it will execute in server b too.

Upvotes: 3

Related Questions