Notify when SQL Server Agent Stops

Question

Notify when SQL Server Agent Stops

Steve Hindle-535638

SSCrazy

Points: 2378
More actions
May 6, 2008 at 8:17 am

#190291

Does anyone know of the quickest way to notify me when the SQL Server Agent service stops unexpectedly?
Regards
Steve

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ryan D. SSCommitted Points: 1595 More actions · Answer 1

I would just query the SQL Agent status. Poll it every few minutes or so. That's the current setup at my place. THe SQL agent status is polled an dumped into a table. Afterwards agent not running triggers an email alert from the monitoring server.

Ryan D. SSCommitted Points: 1595 More actions · Answer 2

Btw here's the query

--print 'Start SQLServerAgent Status'

EXEC master.dbo.xp_servicecontrol 'QUERYSTATE','SQLServerAgent'

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 3

I would also use the Windows service level options to restart the service and perhaps send an email using a script.

Steve Hindle-535638 SSCrazy Points: 2378 More actions · Answer 4

That's great.

Would this have to executed from a different server though?