Failed SQL Agent jobs

To query the Performance Store database for failed agent jobs, use:

select a.*
from dbo.v_agent_jobs a
inner join dbo.v_servers s on s.server_name = a.server_name
where a.run_status = 'Failed'
and a.enabled = 1

Failed agent jobs can also be seen on the Agent jobs dashboard.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.