InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 09:16:59 GMT20http://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxHi Friends i found the below Link http://sqlish.com/alert-when-sql-server-agent-service-stops-or-fails/ThanksWed, 12 Dec 2012 22:02:40 GMTjamessdbahttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxi am also looking for the solutionHi Can you please mention in detailed for me run program is disabled to for the agent serviceThanks in advanceWed, 12 Dec 2012 05:48:16 GMTjamessdbahttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxhi,you can create bat file which will send mail to you whenever sql server agent service get stopped.go to run-->services.msc-->sql server agent service -->property-->recovery option---->run program Tue, 11 Dec 2012 23:52:34 GMTHemant.Rhttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxuse the Get-Service cmdlet, for the service in question, then google for a smtp powershell function and build it up that way, if you get stuck come back with your script so far and I will see where your going wrong.Tue, 11 Dec 2012 03:53:11 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxAnthony,Can you provide me the script and the procedure to do this?Tue, 11 Dec 2012 03:48:45 GMTsqlpantherhttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxCould also write something in powershell as well to check the process state and send an email should it change from started to stoppedTue, 11 Dec 2012 03:36:03 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxYou need to monitor the SQL Server Agent service at OS level using something like SCOM.JohnTue, 11 Dec 2012 03:33:15 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1394995-146-1.aspxHello all,I have many jobs running and for some reason sql server agents stops automatically not sure why..Can someone tell me how can we send email or notify users when my sql sevrer agent stops automatically, i have my dbmail configured...Thanks, Tue, 11 Dec 2012 03:27:05 GMTsqlpanther