Page History

What can you see on the grid information?

Below the Longest Running chart, you can see a job grid representing the same information available in the chart. This information includes:

• 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 trend 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
• Avg 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
• 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.

What other options are available on this 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 trend 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 Print Chart 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.