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.
