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'