Page tree

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.   

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.

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 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 STATUS 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. 
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >