SQL Server Agent : Check the status of Agent XPs Server Configuration Option
Subject : SQL Server agent
Context : At this time, SQL monitor only check the status of the windows service to monitor the SQL Server agent.
but do not check Agent XPs Server Configuration Option.
As a result, you could have a started agent, not able to launch any jobs and sql monitor will not raise an alert.
Solution :
- add a check of the column valueinuse in the sys.configurations table to ensure that Agent XPs is enabled when the agent service is started.
SELECT * FROM sys.configurations WHERE name LIKE 'Agent XPs'
4
votes
![](https://secure.gravatar.com/avatar/4f31203b07d6edbc1d5a2570a228614d?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)