script to check status of sql server/reporting services -> start

• curious_sqldba

  SSC-Dedicated

  Points: 36502

  More actions

  August 4, 2011 at 12:44 pm

  #242565

  can someone please provide a sql script( batch script might be OK, but i would prefer sql script) to do the following:

  i) should be able to check the status of sql server/reporting services every 5 mins

  ii) if services are stopped , should be able to start the services.

  thanks in advance !!!

• RTaylor2208

  SSChampion

  Points: 13298

  More actions

  August 5, 2011 at 10:03 am

  #1364485

  Dont have one to hand but this might help:

  http://www.youdidwhatwithtsql.com/monitoring-starting-services-with-powershell/113

  MCITP SQL 2005, MCSA SQL 2012