The Jobs module collects data on all aspects of SQL Agent jobs, including jobs, steps, history, schedules, and more.
Tables
Jobs module tables are:- Collector.SysJobHistory
- Collector.SysJobs
- Collector.SysJobschedules
- Collector.SysJobsteps
- Collector.SysJobstepslogs
Views
Each table above has an associated Current view, and a Previous view; e.g., Collector.SysJobHistoryCurrent and Collector.SysJobHistoryPrevious.
Each “Current” and "Previous" view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
- ServerName
- ServiceLevel
- Version
- Edition
- Descr