SQL Server Agent Not Running


When the status of a SQL Server agent goes into a state other than "Running", this alert will return a value of 1 (true), otherwise it will return 0 (false). When configuring thresholds for this alert, use the value of 1 as the Critical level and DPA will let you know when the SQL Server agent is not currenty running.


To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return and configure as needed.