Prerequisites

To view a maintenance plan report, you must have either the SELECT ANY TABLE system privilege or the SELECT privilege on the following tables:

• dbo.maint_plan
• dbo.maint_plan_report
• dbo.maint_plan_status

If the database has been upgraded since the last time the maintenance plans were accessed, you receive an error indicating that the maintenance plan tables must be updated. To update these tables, you must have the SELECT ANY TABLE system privilege, and either the CREATE ANY OBJECT system privilege or both the CREATE ANY INDEX and CREATE ANY TABLE system privileges. Click the Maintenance Plans folder to update the tables.