Prérequis

To delete a maintenance plan, 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

You must also have the MANAGE ANY EVENT system privilege, and either the DELETE ANY TABLE system privilege or the DELETE privilege on the maint_plan table.

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.