Alerts on Server Shutdown

  • Can someone please tell me how to alert or notify an operator when any of the SQL Server services become unavailable ? Are there any commands that can capture this information from the event logs and send out email alerts or is there a way to do this from SQL ? Are there any scripts or info available for this, to monitor availability of SQL Services ?

    Thanks

  • You'd probably need to do this from the OS itself and get the notification when services shut down. In W2K you can run a command when a service shuts down (on the recovery tab). You could use this to send an email or something else.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply