SQL Agent Job History
You find the Backup and Recovery monitor in the DBA Cockpit when navigating to Backup and Recovery → SQL Agent Job History.
The SQL Agent Job History monitor displays the list SQL Agent jobs that are scheduled in the SQL server for the last 30 days and their run status.
You can toggle between a view, which shows all database jobs or CCMS Jobs only that are scheduled from the Planning calendar.
The job list contains the following information for each job:
| Field | Description |
|---|---|
|
Job Name |
Name of SQL Agent job |
|
Last Run Date |
Date the step last started execution |
|
Last Run Time |
Time the step last started execution |
|
Last Run Status |
Last run status of the SQL Agent job (0,1,…) |
|
Job Status |
Job status (successful, failed, did not run) |
|
Next Run Date |
Next date on which the job is scheduled to run |
|
Next Run Time |
Next time at which the job is scheduled to run |
|
Job Start Date |
Start date of the SQL Agent job |
|
Job Start Time |
Start Time of the SQL Agent job |
|
Job Enabled |
Status of the SQL job schedule |
|
User Name |
Name of the database user whose account is used when executing the job step |
|
Database Name |
Name of the database in which the command is executed if subsystem is TSQL |
|
SubSystem |
Name of the subsystem used by SQL agent to execute the job step |
|
Job Command |
Job command executed in the SQL Agent job step |
|
Job ID |
Job ID of the SQL Agent job |
You can use the Num of days option to list the SQL Agent jobs for different period of days.