Page History
You can organize and view more specific information in the the Job History tab tab.
To sort the information available on the job events list, click the header of any column, and SQL Enterprise Job Manager orders the information according to the selected column. For example, click Duration to to sort jobs by the duration time.
You can use the View By drop drop-down options on the left side of this tab to specify if you want to view your job history by day, week, or month. Alternatively, you can use the calendar in Date to select a specific date for which you want to view your job history.
If you want to view more specific information, go to the filters section on the left side of the the Job History tab tab and use the filters available there. You can filter your information by:
- Status - filter Filter according to the status of your jobs statusjob: Failed, Successful, Retry, Canceled, SucceededIn Progress, Retry, or Unknown.
Instance -
typeSelect those instances whose jobs you want to see
. Click the respective icons to add or remove an instance. To easily identify your instance names, you can use wildcard characters such as: %, _, [ ], [^], for example, type %dev% and all instances that contain the word "dev" will be included for filtering.
Job name -
typeSelect the names of the jobs for which you want to view their historical information.
Click the respective icons to add or remove jobs. To easily identify your job names, you can use wildcard characters such as: %, _, [ ], [^], for example, type %backup% and all jobs that contain the word "backup" will be included for filtering.- Duration - Type or Duration - use the time slider to define the interval of duration job time for which you want to see the job history
Note |
---|
If your Job name has [ ] characters, replace them by the underscore "_" character so that SQL Enterprise Job Manager does not take them as wildcards and the alert rule is triggered correctly. |
- .
Tip |
---|
When using filters consider:
|
Tip |
You can unselect the option Apply filter as it changes to make all your filter selections first and have your information changed when you finish
|
How do you save filters?
You can save your preferred filtering options by typing a name in Filter Name and clicking in the Add Filter wizard of the Custom Filter section and clicking Save. Once you save your filter, you can retrieve it by selecting the respective name from the it from the drop-down filters options available at the top of the filter sectionbottom of the Custom Filter option available on the left side under the Filter Table By section.
How do you remove filters?
You can remove filters by following these options:
- Use the specific Remove Clear Filter option in each filter. For example, if you want to remove your status filters, click Remove Filter under the same filter section or click the remove icon next to the Instance or Job Name filter. Clear Filter.
- Under Applied filters on Under FILTERED BY on the top section or your your Job History tab tab, you can see those the filters that you have selected, click the X icon next to the ones you want to remove.
- Use the option Clear All Filters on the top section of the Filter Table By to remove all filters.
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...