March 7, 2010 at 9:58 pm
Is it possible to get an email notification in SQL Server 2000, when an SQL Server Agent Stops?
March 9, 2010 at 3:35 am
You can get an alert if a service fails by using facilities in Windows.
Right-click on My Computer and select Manage. Navigate to Services and locate the SQL Agent service. Right-click on SQL Agent and select Properties, then select the Recovery tab.
You can specify a program to run if SQL Agent fails. The program you run can be CSCRIPT or Powershell, with parameters to call a script you write to send the alert and restart SQL Agent. This will alert you if SQL Agent fails, but not if it stops because someone has deliberately stopped it.
It is also worth checking if your Windows or Security staff are running any monitor program that checks the status of services. If they are you may be able to get an email alert added to the monitor for any time SQL Agent stops.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply