Jeff Moden (8/24/2014)
Steve Jones - SSC Editor (8/24/2014)
Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).You don't want to do this in SQL Server. [font="Arial Black"]Use Windows at the service level to check if the service is running[/font], and if not, send an email that way.
How would one do such a thing?
As a bit of a side bar and a play on words, "Just because you can do something in SQL Server, doesn't mean you SHOULDN'T"! 😉
Well for one - there's SQLH2 (SQL Server health and history tool) from MS. Download, install, and configure. Barring that - there are literally dozens of WMI monitoring tools which can do this with a few clicks.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?