January 6, 2012 at 1:57 pm
How can i send email notification to a group of users when a sql server is stopped and started back. I have an auto shcdule to restart the servers but would also like to notificy all the users abiout it.
January 6, 2012 at 2:13 pm
Monitoring Software or you would need to get something created through a batch file to attach to that job that stops and restarts the service. Preference is monitoring software.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 13, 2012 at 4:19 pm
For starting you could always create a SQL startup proc that sends an email (or a SQL Agent job that does the same when the Agent starts).
Otherwise you're going to be looking at remote monitoring of the processes.
January 13, 2012 at 5:09 pm
For stopping on failures, the OS may have a mechanism for sending an email on service stop. Depends on your version.
For manual stops, I'm not sure there is anything other than monitoring software.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply