Versions Compared

Key

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

...

To sort the information available on the job events list, click the header of any column, and SQL Enterprise Job Manager orders the information according to the selected column. For example, click click Duration to sort jobs by the duration time.

You can use the View By drop 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. 

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

  • Status  - filter Filter according to the status of your jobs statusjob: Failed, Successful, Retry, Canceled, In Progress, or Unknown.  
  • Instance  - select Select those instances whose jobs you want to see. 

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

  • Duration - type Type or use the time slider to define the interval of duration job time for which you want to see the job history.
Tip

When using filters take into accountconsider:

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

...

You can save your preferred filtering options by typing a name in the Add Filter wizard of the Custom Filter section, section and click clicking Save. Once you save your filter, you can retrieve it from the drop-down bottom of the Custom Filter option option available in on the left side under the Filter Table By section. 

...