Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to notify when SQL Server Agent stopped automatically? Expand / Collapse
Author
Message
Posted Tuesday, December 11, 2012 3:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 4:14 AM
Points: 38, Visits: 198
Hello 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,
Post #1394995
Posted Tuesday, December 11, 2012 3:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:51 AM
Points: 5,438, Visits: 10,140
You need to monitor the SQL Server Agent service at OS level using something like SCOM.

John
Post #1394999
Posted Tuesday, December 11, 2012 3:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:10 AM
Points: 5,221, Visits: 5,119
Could also write something in powershell as well to check the process state and send an email should it change from started to stopped



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1395001
Posted Tuesday, December 11, 2012 3:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 4:14 AM
Points: 38, Visits: 198
Anthony,
Can you provide me the script and the procedure to do this?
Post #1395007
Posted Tuesday, December 11, 2012 3:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:10 AM
Points: 5,221, Visits: 5,119
use 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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1395011
Posted Tuesday, December 11, 2012 11:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
hi,

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
Post #1395449
Posted Wednesday, December 12, 2012 5:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 7, 2014 1:57 AM
Points: 89, Visits: 1,075
i am also looking for the solution

Hi Can you please mention in detailed for me run program is disabled to for the agent service

Thanks in advance



Post #1395615
Posted Wednesday, December 12, 2012 10:02 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 7, 2014 1:57 AM
Points: 89, Visits: 1,075
Hi Friends i found the below Link

http://sqlish.com/alert-when-sql-server-agent-service-stops-or-fails/

Thanks
Post #1395979
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse