Page History
...
- 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.
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 top right corner of the job trend chart. icon located on the
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...