Skip to main content
< All Topics
Print

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)
dbo.v_agent_job_definitions (Agent job definitions, including history of all Agent job changes)

Other relevant views in the Performance Store database:
dbo.v_latest_stats
dbo.v_agent_job_executions (Visual overview of all Agent job executions, their duration and execution status)

Table of Contents