Results 1 to 3 of 3

Thread: checking agents

  1. #1
    Join Date
    May 2002
    Posts
    95

    Unanswered: checking agents

    I have around 25 sql servers(sql server 2000) all on windows server 2003. i would like to know if anyone has a script that will poll all the servers and check to make sure the agent is running.

    thanks for your help

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Quote Originally Posted by ricka49
    I have around 25 sql servers(sql server 2000) all on windows server 2003. i would like to know if anyone has a script that will poll all the servers and check to make sure the agent is running.

    thanks for your help
    These can help you
    http://www.databasejournal.com/featu...le.php/3491201

    http://www.sqlservercentral.com/arti...ningjobs/1897/
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  3. #3
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    Try these:

    exec master..xp_servicecontrol querystate, MSSQLSERVER
    exec master..xp_servicecontrol querystate, SQLServerAgent

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •