I've a small Question on Creating Alerts. I know how to create alerts from SQL Server Agent if any Job fails. Could you please let me know how to set/create alerts when the Agent Service or SQL DB Engine Service itself stops. We have lot of Standalone and Clusterd SQL Servers. Can we create a alert through out all our servers(our Domain), so that it shoots an e-mail whenever a SQL Service is stopped without using any 3rd party tool.
Thanks in Advance! I really appreciate your help.
Thanks and Warm Regards, Sri Reddy.