This blog is part of the blog series named SQL Server Monitoring.
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.
Report
The report has 2 tables where the upper one list daily and weekly recurring jobs, and the lower table list all other jobs.
Model
The model for the report uses the 2 facts [Agent jobs – grid] and [Agent jobs – list], and the dimension [Agent jobs – jobs].
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.
