automating checks

• sql_prodigy

  SSCrazy

  Points: 2254

  More actions

  March 27, 2009 at 4:01 am

  #129441

  Hi everyone

  is there anyway i can automate checking whether SQL server agent and the SQL service is running,

  but also notifying certain people via email that its down...

  thanks

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  March 27, 2009 at 4:21 am

  #967274

  yisaaacs (3/27/2009)

  ---

  Hi everyone

  is there anyway i can automate checking whether SQL server agent and the SQL service is running,

  but also notifying certain people via email that its down...

  thanks

  You can use this command to see whether your server is running:

  EXEC master.dbo.xp_servicecontrol 'QUERYSTATE', 'SQLAgent'

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  March 27, 2009 at 9:00 am

  #967504

  Krishna (3/27/2009)

  ---

  yisaaacs (3/27/2009)

  ---

  Hi everyone

  is there anyway i can automate checking whether SQL server agent and the SQL service is running,

  but also notifying certain people via email that its down...

  thanks

  You can use this command to see whether your server is running:

  EXEC master.dbo.xp_servicecontrol 'QUERYSTATE', 'SQLAgent'

  Nice, did not know that, another tip learned

  although it'll be ironic, if MSSQLSERVER is not running, you cannot run the above command to check the service 😛

  Here is another SSC's thread to explain more

  http://www.sqlservercentral.com/Forums/Topic14726-5-1.aspx

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  March 27, 2009 at 10:21 am

  #967586

  Jerry Hung (3/27/2009)

  ---

  Krishna (3/27/2009)

  ---

  yisaaacs (3/27/2009)

  ---

  Hi everyone

  is there anyway i can automate checking whether SQL server agent and the SQL service is running,

  but also notifying certain people via email that its down...

  thanks

  You can use this command to see whether your server is running:

  EXEC master.dbo.xp_servicecontrol 'QUERYSTATE', 'SQLAgent'

  Nice, did not know that, another tip learned

  although it'll be ironic, if MSSQLSERVER is not running, you cannot run the above command to check the service 😛

  Here is another SSC's thread to explain more

  http://www.sqlservercentral.com/Forums/Topic14726-5-1.aspx

  oops sorry typo meant to say sql agent:-D