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

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 12, 2012 at 8:59 am

  #1432615

  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

  January 12, 2012 at 9:02 am

  #1432621

  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

  January 12, 2012 at 9:08 am

  #1432630

  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

  January 12, 2012 at 9:11 am

  #1432637

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

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 12, 2012 at 9:13 am

  #1432642

  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

  January 12, 2012 at 9:13 am

  #1432643

  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

  January 12, 2012 at 9:18 am

  #1432648

  thanks Jason i am checking your link.