Page History
The Job
Trend viewTrends view allows you to explore the most important job trends of your environment. According to your requirements, you can choose different job trend chart types, trend durations, and filters.
How do you specify the Job Trend type?
On
thethe the left section of
thethe Job
TrendTrends view, you can select any of the following trending charts from
thethe Job Trend
TypeType drop-down
options:
Click the respective job trend chart type to view more information about this trend.
How do you select the trend duration?
TheThe Trend Duration drop-down options allow you to choose if you want to see job trend type information per Day, Week, Month, or Year. For example, you can select to
seesee Most Frequent
jobsjobs of the week. For any of these options, SQL Enterprise Job Manager displays the following information:
- Day - job trends based on the job durations duration collected over the past 24 hours and forecasts for the next 24 hours.
- Week - job trends based on the job durations duration collected over the past 7 days and forecasts for the next 7 days.
- Month - job trends based on the job durations duration collected over the past 30 days and forecasts for the next 30 days.
- Year - job trends based on the job durations duration collected over the past 12 months and forecasts for the next 12 months.
How do you filter the information on the Job
TrendingTrends tab?
After youAfter you select the time range for which you want to see the information, you can filter your information according to the following fields:
- Instance -
...
- select the instances for which you want to see the job trend information.
...
- Job Name -
...
- select specific jobs to be displayed in the trending information.
...
- Category - choose specific job categories for which you want to see the trend information.
...
- Duration - use the sliders to determine a specific duration interval that jobs must comply in order to be displayed on the trending information.
How do you save filters?
You can save your preferred filtering options by typing a name in Filter Name and clicking Save. Once you save your filter, you can retrieve it by selecting the respective name from the drop-down filters options available at the top of the filter section.
...
When using filters take into account:
Tip |
---|
When using filters take into account:
|
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
What other options are available on the Job Trend Chart?
You can also perform the following actions:
- 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).
- Search Jobs - to search your jobs, use the searcher located on the top right corner of the Job Trend chart.
- Print chart - if you want to print the displayed chart, select the Print Chart option by clicking theicon on the bottom 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 theicon located on the bottom right corner of the Job Trend chart chart.
- View By - select the jobs (monitored jobs, job trends, job chains, tasks, job history, or task history) you would like to see.
- Refresh - to get the latest information, click the gear icon located on the right corner of the View By section.
Tip |
---|
You can hover over a specific job on the graphic to see job details such as: date, name, instance and status. |
Scroll pdf ignore |
---|
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > > |
...