NO THIRD PARTY TOOLS PLEASE!
I am looking for some methods of being able to send an alert/e-mail if a SQL server on my network goes down….I would like some ideas/code/methods on the following two concepts.
1) Does anyone have experience w/setting up SHUTDOWN ALERTS (ie 17147 or 17148) and actually have the SQL Server alert you if this occurs. Can this be done using Event Forwarding to monitor remote SQL servers? How does it work?
2) How can I monitor if the SQL Server Service goes down on a particular server? Is there a way to read the registry, know when a service is running/stopped? I know the scm (service control mgr) has an action parameter. Is there a way to incorporate this into a VBscript/VB app….How is this done? TIA