Versions Compared

Key

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

The The Job History tab  tab lists chronologically all jobs events of your managed instances. SQL Enterprise Job Manager displays an entry entry each time a job runs

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

On this list you can see the following values:

  • Status - displays Displays the status of each job event: failed, successful, retry, canceled, or unknown. Take into account that this is not the status of the job itself but of each event (every time the job runs).
  • Date time /Time - displays Displays the date and time of each job event, including the time zone. 
  • Duration - shows Shows the duration in hh:mm:ss of each job event (total duration of all steps executed for that job).
  • Instance Instance - displays Displays the name of the SQL Server instance where the job ran.
  • Job Name Name - shows Shows the name of the respective job.
  • Max Run Time Time - the The maximum run time of a job step in the job event
  • Avg Run Time Time - the The average run time of job steps in the job event
  • Message Message - displays Displays additional information of the job event: status, schedule used, the last step ranrun, etc. 
Tip
  • The status of job events
are
  • is represented with the following icons: Image Modified Successful, Image Modified Canceled, Image Modified Failed, Image Modified Retry, or Image Modified Unknown.
  • Click the Image Added more options icon to select the information you want to hide or show on the Job History view.

How can you export the information available on Job History?

To export the information displayed in the current view of the the Job History tab tab, click the option option Export on  on the top bar menu and select your required format: PDF, CSV, or XLS for exporting the information displayed.

How do you refresh the information available on the Job History tab?

Whenever there is new information to be updated on the Job History tab, the option Refresh  tab, the Image Added Refresh option (located on the top of this tab) becomes available so you can click and update it to the latest information. 

Tip

Additionally, you can drill into any job event to see specific details about its steps. For more information on what is available when drilling into job events go to to Viewing the steps of your job

To learn how to order and filter the information on the Job History tab, go to Organizing and filtering your job history information. 

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

...

What other options are available on the Job History tab?

Whenever you want to see your Task History, click this option located on the top right side of this view.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...