Post reply

Running a job across instances/servers in same domain

  • July 6, 2009 at 5:39 am

    #134033

    Hi

    I have a job which gives the list of all server jobs on execution.

    But this job is extractind details from one server only ( in Prod)/

    I want that it shud extract the details from all the servers in prod.

    Can any1 tell me how to do that.

    I have 2 servers/instances in Prod . They are linked also. Wat shud b d next step?

  • July 6, 2009 at 8:10 am

    #1020404

    You have to link the job to other servers (linked servers), or set it to run on all server instances. There is no linkage between instances to automatically determine what is production and what is not.

    SQLSentry makes a great tool to help with this problem.

Viewing 2 posts - 1 through 1 (of 1 total)

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