Post reply

How to enable Target Multiple Server option in SQL Agent

  • 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

  • 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

  • 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?

  • 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

  • January 12, 2012 at 9:11 am

    #1432637

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

  • 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

  • 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.

  • January 12, 2012 at 9:18 am

    #1432648

    thanks Jason i am checking your link.

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

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