May 25, 2010 at 10:42 am
I have run into an issue on one of our SQL Servers where a system error shuts down SQL Server Agent (it basically crashes). We have identified the problem but the fix means rebuilding the server and the resources will not be available to do so for several weeks.
Does anyone know of a way to have the Operating System send and alert (email would be best) telling the administrative team that the SQL Server agent service isn't running? Right now we are trying to check it regularly or we find out because a scheduled report doesn't run.
Any ideas would be greatly appreciated.
Thank You
Cory
May 25, 2010 at 10:55 am
Most of the OS service properties have the ability to run a program if it stops. You can set up a notification with that. Check the recovery tab for the service.
May 25, 2010 at 11:12 am
Great, thanks for the tip. I'll pass it on to the sys admins and see if they can set something up.
Much Appreciated.
Cory
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply