SQL Server Monitoring – Agent Jobs

Published January 26, 2022.

Purpose

To list agent jobs and their schedules.

Sources

This feature queries the MSDB tables dbo.sysjobs, dbo.sysjobschedules and dbo.sysschedules which returns information for the agent jobs and their schedules.

Reports

The report page Agent Jobs has two tables, one that list daily and weekly recurring jobs in a grid, while all other jobs are listed in a table.

Model

The model for the report uses the facts [Agent jobs – grid] and [Agent jobs – list].

Configuration

There is no configuration for this feature.

Scheduling

The default schedule for the feature is once every day between 06:00 and 07:00.

Retention

The default retention for the table dbo.fhsmAgentJobs is 90 days.