November 17, 2009 at 8:24 am
Hi,
Is there any way to get alert when SQL server agent or other services get stopped without using any external tools? Because sometimes when agent is stopped due to some reason, maintenance jobs stopped without getting any notifications.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
November 17, 2009 at 8:50 am
You could set something up that will send an e-mail when the service stops. You'd have to write a program to send the alert, and then go to the properties on the service from the system manager and set it up to run that.
Most people would use a monitoring tool for that kind of thing. There are plenty that will monitor Windows services for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2009 at 9:17 am
if you want to do it locally then you can try writing a powershell script and run it on a schedule
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply