January 12, 2012 at 8:53 am
Hi folks.
like to know how can we enable Trarget Multiple Server Option . By default its disable .
SQL Agent --> new Job-->Tragets.
Thanks
January 12, 2012 at 8:59 am
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
January 12, 2012 at 9:02 am
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?
January 12, 2012 at 9:08 am
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
January 12, 2012 at 9:11 am
No Not yet that what i am wondering what are the steps to finish this .
January 12, 2012 at 9:13 am
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
January 12, 2012 at 9:13 am
Please read the articles Jason has already suggested. It will guide you on, what you are looking for.
January 12, 2012 at 9:18 am
thanks Jason i am checking your link.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy