Disassociates the specified maintenance plan from the specified database.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
|Applies to: SQL Server (SQL Server 2008 through current version).|
sp_delete_maintenance_plan_db [ @plan_id = ] 'plan_id' , [ @db_name = ] 'database_name'
[ @plan_id =] 'plan_id'
Specifies the maintenance plan ID. plan_id is uniqueidentifier.
[ @db_name =] 'database_name'
Specifies the database name to be deleted from the maintenance plan. database_name is sysname.
0 (success) or 1 (failure)
sp_delete_maintenance_plan_db must be run from the msdb database.
The sp_delete_maintenance_plan_db stored procedure removes the association between the maintenance plan and the specified database; it does not drop or destroy the database.
When sp_delete_maintenance_plan_db removes the last database from the maintenance plan, the stored procedure also deletes the maintenance plan.
Only members of the sysadmin fixed server role can execute sp_delete_maintenance_plan_db.
Deletes the maintenance plan in the AdventureWorks2012 database, previously added by using sp_add_maintenance_plan_db.
EXECUTE sp_delete_maintenance_plan_db N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC', N'AdventureWorks2012';