April 21, 2008 at 5:13 pm
Simple task; Send me an email alert if SQL Server shuts down (Error number 17147)
I defined my alert, and have tested email capabilities on the Server(all is working properly, as Im able to test alert my email account)
Now, when I restart the server, I expect to receive an email that notifies me that the Server was shut down, but nothing happens. Im assuming that because SQL Agent Server gets shut down when I restart the computer, its not able to notify me.
How have you gotten around this problem ?
Do I look in the Event viewer and try to look for a 'system is starting back up' error number, so therefore I somewhat get notified after the fact that the Server was shut down ? (I was not able to find such an error number, but please point me in the right direction)
Thank you
April 21, 2008 at 9:52 pm
Use the ability of the OS Services to send a note when the service stops. You can script the mail sending from there.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply