Page History

You can filter the information displayed on your calendar Calendar view to see more specific information. On the left side of your Schedule tab, you can find the filtering section the Filter Table By section where you can filter jobs and tasks by:

• Status  - select Select the specific job and task status to display: Failed, SucceededSuccessful, Retry, Canceled, Running, or Scheduled

• Instance

   

  -

  type those

  Select the instances whose jobs and tasks you want to see on the calendar view

  . Click the respective icons to add or remove an instance (Image Removed, Image Removed). To easily identify your instances names, you can use wildcard characters such as: %, _, [ ], [^],for example type %dev% and all jobs that belong to all instances that contain the word "dev" will be included in the calendar section

  .

   

• Job

  name

  Name  -

  type

  Select the names of

   jobs

  jobs you want to see on your calendar view

  . Click the respective icons to add or remove jobs (Image Removed, Image Removed). To easily identify your jobs 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 use the sliders to determine the time range that SQL Enterprise Job Manager will use to filter your jobs on the Schedule tab.   

...

• jobs and tasks.
• Job/Task - Select if you want to see jobs or tasks. 

How do you save filters? 

You can save your preferred filtering options by typing a name in the Add Filter wizard of the Custom Filter section and clicking Save. Once you save your filter, you can retrieve it from the drop-down bottom 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 STATUS Filter under the respective section. Clear Filter.
• Under Applied Filters on Under FILTERED BY on the top section or your Schedule tab, you can see those the filters that you have selected, click the Image RemovedX icon next to the ones you want to remove.
• Use the option Clear All Filters on the top of the filters section to section of the Filter Table By to remove all filters. 

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

...

...