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
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:
3) Navigate to the failure and click the + to get the full details on the job execution failure
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.