Skip to main content
How can we help?
< All Topics
Print

Agent job step with non-existing database

If an agent job is having a job step with a non-existing database or an offline database, this alert will be thrown.

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

select *
from dbo.v_agent_jobs s with (nolock)
where s.steps_with_non_existing_databases = 1

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.

Table of Contents