How can we help?
Agent jobs dashboard
The Agent jobs dashboard contains information about SQL Server Agent jobs:
Since information about run durations (current, min, max and average) is available, it is e.g. possible to create a custom stat to trigger an alert if a job run duration is deviating too much from the average.
Corresponding views in the Performance Store database:
dbo.v_agent_jobs
dbo.v_agent_jobs_all (includes historic data for agent jobs that does not exist anymore)
Other relevant views in the Performance Store database:
dbo.v_latest_stats