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.
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. |