Troubleshooting Jobs with Job Diagnostics

Job Diagnostics reports why a job did not run. Use this feature to troubleshoot jobs that are not running as scheduled. A list of reasons why a job might not run appears on this tab. Before you can run the job diagnostics report to troubleshoot problems, you must enter both a job ID and an instance name on the Job Diagnostics tab.

After running the report, a pass or fail icon next to each reason in the list indicates which of them may be contributing to the job not running. Next to the fail icon, there is a recommended resolution. The resolution may include removing the job from the database. To do this, click the Remove Job button or the Copy to clipboard link.

The following table describes the job resolutions.

Field

Description

Remove Job

Removes the option that automatically removes the job from the database. This is the quickest method if your server policy permits.

Copy to clipboard

Copies the option that copies the command to the clipboard if it is necessary to run it on SQL Server directly. This may be necessary depending on your server policy.