How to notify when SQL Server Agent stopped automatically?

Question

Viewing 8 posts - 1 through 7 (of 7 total)

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

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

John

Ant-Green SSC Guru Points: 113445 More actions · Answer 2

Could also write something in powershell as well to check the process state and send an email should it change from started to stopped

sqlpanther Ten Centuries Points: 1204 More actions · Answer 3

Anthony,

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

Ant-Green SSC Guru Points: 113445 More actions · Answer 4

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.

Hemant.R Ten Centuries Points: 1286 More actions · Answer 5

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

jamessdba SSCrazy Points: 2254 More actions · Answer 6

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

jamessdba SSCrazy Points: 2254 More actions · Answer 7

Hi Friends i found the below Link

Thanks