Skip to main content
InSource Solutions

TN Hist253 How to view the job history of a SQL Server maintenance plan

InSource_Logo_Transparent.png

Description

 

This article from InSource shows how to check the job history for a SQL Server maintenance plan. This is useful when you have had an execution failure and would like to gather more information on when and why the failure occurred.

  • Author: Joseph Hefner
  • Published: 5/25/2016
  • Applies to: SQL Server 2005 and later

Details

1) Open SQL Server Management Studio and navigate to SQL Server Agent \ Jobs

2) Right click on the Maintenance Plan that you wish to view the history for and choose "View History" as below:

SS1.JPG

 

3) Navigate to the failure and click the + to get the full details on the job execution failure

SS2.JPG

 

Often times, failures are due to either restricted permissions on the account that is executing the job as in this example or unable to execute because another job is already running. When this is the case the execution time should be modified so that the 2 jobs  do not try to execute at the same time.