If you need to get a specific view of the jobs displayed on this tab, filter your information using the options available on the left section of this tab.
Filter your jobs by:
- Status - select specific job status to filter your information such as: Not idle or suspended, Executing, Waiting for thread, Between retries, Idle, Suspended, or Performing completion actions.
- Job Name - type specific jobs names. Click the respective icons (
) to add or remove job names. 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. - Enabled - select if you want to view Enabled (Yes) or Disabled (No) jobs.
- Category - select specific jobs' categories. For example, you can select to view all Log Shipping or Full-text jobs. Click more to display all categories.
- Instance - type those instances for which you want to see their jobs. Click the respective icons ( ) to add or remove instance names. 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.
- Last updated by - use this filter when you want to view last updated jobs by specific user names. Type the user names in the following format: domain\username.
- Job Chain Name - type specific job chain names for which you want to view job information.
If your Job name has [ ] characters, replace them with the underscore "_" character so that SQL Enterprise Job Manager does not take them as wildcards and the alert rule is triggered correctly.
When you select your filters, you can choose to disable the option Apply filter as it changes, so that you can select your filters first and apply the changes later.
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.
How do you remove filters?
You can remove filters by following these options:
- Use the specific Remove Filter option in each filter. For example, if you want to remove your status filters, click Remove Filter.
- Under FILTERED BY on the top section or your Jobs tab, you can see the filters you have selected, click the X icon next to the ones you want to remove.
- Use the option Clear on top of the filters section to remove all filters.