Deletes the specified maintenance plan.
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 [ @plan_id = ] 'plan_id'
[ @plan_id =] 'plan_id'
Specifies the ID of the maintenance plan to be deleted. plan_id is uniqueidentifier, and must be a valid ID.
0 (success) or 1 (failure)
sp_delete_maintenance_plan must be run from the msdb database.
Only members of the sysadmin fixed server role can execute sp_delete_maintenance_plan.
Deletes the maintenance plan created by using sp_add_maintenance_plan.
EXECUTE sp_delete_maintenance_plan 'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC';