Running the Job Diagnostics Report

The Jobs Diagnostic report help you determine whether jobs are running successfully and help you troubleshoot problems. A pass or fail icon appears next to each common problem, and a recommended resolution appears next to each fail icon.

Before you can run the job diagnostics report to troubleshoot problems, you must have both a job ID and an instance name.

Run the Job Diagnostics report

  1. Go to the Job Diagnostics tab.

    1. Go to Plugins.
    2. Click Job Engine Manager.
    3. Click Job Diagnostics.
  2. In the Job ID field, do 1 of the following:
    • Type the job ID.

    • Paste the job ID from the Jobs tab.

      1. Go to the Jobs tab.
      2. Right-click the job you want to copy, and click Copy Job ID.
      3. Return to the Job Diagnostics tab.
      4. In the Job ID field, right-click and click Paste.
  3. In the Instance Name field, do 1 of the following:
    • Type the instance name.

    • Paste the instance name from the Jobs tab.

      1. Go to the Jobs tab.
      2. Right-click the job you want to copy, and click Copy Instance Name.
      3. Return to the Job Diagnostics tab.
      4. In the Instance Name field, right-click and click Paste.
  4. Click Run Diagnostics.

    If a problem is diagnosed and the recommended resolution is to remove the job, do 1 of the following:

    • Click Remove Job to run the command to remove the job if your server policy permits.
    • Click the Copy to clipboard link to copy the command to the clipboard for manual removal on the SQL server.