Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 (Image Removed Image Removed) 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. 

     - select your job name from the list available.

  • Enabled 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

    select your instances for which you want to see their jobs.

     Click the respective icons (Image Removed Image Removed) 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.   

  • Updated by  Last updated by - use this filter when you want to view last updated jobs by specific user names. Type Select the user names in the following format: domain\username. 
  • Job Chain Name - type select a specific job chain names for which you want to view job information.
  • Last Run Outcome 


     
Note

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.

  • -  select specific job status to filter information according to the last run outcome values reported such as: Failed, Successful, Retry, Canceled, In Progress, Unknown.

Tip

When using filters take into account:

  • Some filters have the option to Add Filter in case the information you are looking for is not listed. Once you click on Add Filter, a dialog box appears. Type the name you are looking for on the Search bar, then select it from the list, and Save. Your filter will be included under the filter list where you Added.
  • Click the respective checkbox to add or remove your selections.
  • If you want to select
Tip
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, deselect the Apply Filter Instantly option.

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 click 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 in 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 specific Clear Filter option  option in each filter. For example, if you want to remove your status filters, click Remove click Clear Filter.
  • Under FILTERED BY Under Applied filters on the top section or your your Jobs tab tab, you can see the filters you have selected, click the the X icon  icon next to the ones you want to remove.
  • Use the option option Clear All Filters on the top of the filters section to section of the Filter Table By to remove all filters. 


Scroll pdf ignore
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...