Versions Compared

Key

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

...

  • Status - 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 - displays the date and time of each job event, including the time zone. 
  • Duration - shows the duration in hh:mm:ss of each job event (total duration of all steps executed for that job).
  • Instance - displays the name of the SQL Server instance where the job ran.
  • Job Name - shows the name of the respective job.
  • Max Run Time - the maximum run time of a job step in the job event
  • Avg Run Time - the average run time of job steps in the job event
  • Message - displays additional information of the job event: status, schedule used, last step ran, etc. 
Tip

The status of job events are represented with the following icons: Image Modified Successful, Image Modified Canceled, Image Modified Failed, Image Modified Retry, or Image Modified Unknown.

Click the Image Modified gear 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?

...