You can organize and view more specific information in the Task History tab. 

To sort the information available on the task history list, click the header of any column, and SQL Enterprise Job Manager orders the information according to the selected column. For example, click Last Run to sort tasks by the date and time of the last task run.

If you want to view more specific information, go to the filters section on the left side of the Task History tab and use the filters available there. You can filter your information by:

  • Status - Filter according to the status of your tasks: Unknown, Disabled, Ready, Running,  Failed, Successful, Retry, Canceled, In Progress, or Unknown.
  • Task Name - Select the name of your task.
  • Server Name - Select the name of the computer on which the task occurs.

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 it.
  • Click the respective checkbox to add or remove your selections.
  • If you want to select 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 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 Clear Filter option in each filter. For example, if you want to remove your status filters, click Clear Filter.
  • Under Applied filters on the top section or your Task History 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 All Filters on the top section of the Filter Table By to remove all filters. 


IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels