How to notify when SQL Server Agent stopped automatically?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to notify when SQL Server Agent stopped...

How to notify when SQL Server Agent stopped automatically?

Rate Topic

Display Mode

Topic Options

Author

Message

sqlpanther

Posted Tuesday, December 11, 2012 3:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:29 AM
Points: 26, Visits: 130

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

John Mitchell-245523

Posted Tuesday, December 11, 2012 3:33 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 4,418, Visits: 7,170

You need to monitor the SQL Server Agent service at OS level using something like SCOM.

John

Post #1394999

anthony.green

Posted Tuesday, December 11, 2012 3:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

sqlpanther

Posted Tuesday, December 11, 2012 3:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:29 AM
Points: 26, Visits: 130

Anthony,
Can you provide me the script and the procedure to do this?

Post #1395007

anthony.green

Posted Tuesday, December 11, 2012 3:53 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1395011

Hemant.R

Posted Tuesday, December 11, 2012 11:52 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 7:20 AM
Points: 45, Visits: 174

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

jamessdba

Posted Wednesday, December 12, 2012 5:48 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 2:15 AM
Points: 72, Visits: 796

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

jamessdba

Posted Wednesday, December 12, 2012 10:02 PM

Valued Member

Group: General Forum Members
Last Login: Today @ 2:15 AM
Points: 72, Visits: 796

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 »

Permissions