By selecting the option Longest Running Jobs from the Job Trend Type options on the Job Trend view, you can see the jobs that have the longest time durations in your environment.
- Select the time range in the Trend Duration drop-down options. Choose to view the information by Day, Week, Month, or Year.
- Filter the information by Job Name, Instance, Category, and Duration.
For example, you can select to view the Longest Running Jobs from last month for Instance A or the Longest Running Jobs from last Week for those jobs that have a Data Collector category.
Take into account that when you select a time range for the Trend Duration option, SQL Enterprise Job Manager displays job trends based on jobs collected over the past selected time range and forecasts this information for the same period of time in the future.
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.
You can hover over a specific job on the graphic to see job details such as: date, name, instance and status.