Table 1: System Table
System Table Description
syscategories all categories defined for the local server
sysdownloadlist lists all the jobs downloaded from master to a target server
sysjobhistory displays the execution history for all local jobs
sysjobs holds the core definitions for each job
sysjobschedules the schedule information (e.g., frequency, status)
sysjobsservers the servers that the job is to run on
sysjobsteps the execution attributes for the job (e.g., on failure, what to run)
systaskids a mapping of tasks from earlier releases of SQL Server