Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Job Name - the name of the job included in the chart
  • Instance - the name of the SQL Server instance where the job resides
  • Category - the category of the job used for the trending chart
  • Min Duration - the minimum job duration according to all runs executed in the specific time range
  • Max Duration - the maximum job duration according to all runs executed in the specific time range
  • Average Duration - the average job duration according to all runs executed in the specific time range
  • Last Run Date - the date and time the last job run was executed 
  • Count - the number of times the job was executed in the specific time range
  • Failure - the number of times the job failed in the specific time range
  • Trend % - the trend frequency % used for calculating the trend

To view all events/runs for each job, expand the respective job and SQL Enterprise Job Manager displays each job run/event with its status, duration, and corresponding message information.

How What other options are available on the Job Trend Chart?

You can also perform the following actions:

  • Refresh - to get the latest information, use the Refresh option located on the top left corner of the job trending chart.
  • Hide trend lines - select the option Hide Trend Lines located on the top left corner of the job trend chart to hide trend lines (dotted lines) and view only historical data (hard lines).  
  • Print chart - if you want to print the displayed chart, select the Print Chart option by clicking the  icon on the top right corner of the job trend chart. 
  • Download chart - you can download your job trend chart as a PNG, JPEG image file, PDF document, or SVG vector file. Find these options under the  icon located on the top right corner of the job trend chart.

...