Verifying the database maintenance plan status
- Open and log in to Microsoft SQL Server Management Studio.
- In the tree-view, open the Management | Maintenance Plans nodes.
- Right-click on a plan and select View History. The Log File Viewer window opens.
- View the status report.
If an error occurs, it is likely that the SQL Server Agent is not started. Start the service and start over.