Versions Compared

Old Version 1

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version 2

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

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

To sort the information available on the job events 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 Duration to sort jobs Last Run to sort tasks by the duration time.You can use the View By drop-down options on the left side of this tab to specify if you want to view your job history by day, week or month. Alternatively, you can use the calendar in Date to select a specific date for which you want to view your job history. 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 Job History Task History tab and use the filters available there. You can filter your information by:

  • Status - filter according to your jobs tasks status: Unknown, Disabled, Ready, Running,  Failed, Successful, Retry, Canceled, In Progress, or Unknown.  

  • Instance - select those instances whose jobs you want to see. 

    Note
    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. 

  • Job name - select the names of the jobs for which you want to view their historical information.

    Note
    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.
    • Duration - use the time slider to define the interval of duration job time for which you want to see the job history

...

  • Task Name - select the name of your task.
  • Server Name - select the name of the computer on which the task occurs

...

  • .
Tip

When using filters take into account:

  • Click the respective checkbox to add or remove your selections.
  • 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 located on the left side, and Save. Your filter will be included under the filter list where you Added.
  • If you want to select filters first and apply the changes later, deselect the Apply Filter Instantly option.

...

  • 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 Job 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. 

...