How to validate a SQL Server Maintenance Plan execution for a backup process? SQL Server 2012
Provided custom SQL Server Database Maintenance Plan and recommended reviewing step 15 �For each job that was created by the maintenance plan right click on the job and select properties:� The job properties Alerts and Notifications will tell you what should be happening and what the SQL job is supposed to do when events occur (alerts and notifications of job results). However, perhaps the most reassuring way to determine when the job ran and what happened is to look at the �Job Activity Monitor� from within SQL Server Management Studio > SQL Server Agent > Job Activity Monitor. You can see all jobs that were run, and if they have been successful.
Close Date: 5/11/2017 12:56