How to enable Target Multiple Server option in SQL Agent

Question

Post reply

How to enable Target Multiple Server option in SQL Agent

SQlLogic

SSCrazy Eights

Points: 9686
More actions
January 12, 2012 at 8:53 am

#249514

Hi folks.
like to know how can we enable Trarget Multiple Server Option . By default its disable .
SQL Agent --> new Job-->Tragets.
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Let's start by finding out what you have done so far.

Have you followed the steps in this article?

http://msdn.microsoft.com/en-us/library/ms186273.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 2

I want to create new job and target as multiple server .but i saw that option is disable . so i want to know how to setup this new job for multiple target server?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Have you created a master server? Have you created the target servers? Are you trying to create the job from the master server?

In the link I provided, it discusses that and then provides a link to how to create those servers

http://msdn.microsoft.com/en-us/library/ms180992.aspx

This is why I asked what have you done so far. If you have not created the master server, then that is where you need to start.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 4

No Not yet that what i am wondering what are the steps to finish this .

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Check the second link I provided.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 6

Please read the articles Jason has already suggested. It will guide you on, what you are looking for.

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 7

SQlLogic

SSCrazy Eights

Points: 9686

January 12, 2012 at 9:18 am

#1432648

thanks Jason i am checking your link.