sp_delete_maintenance_plan
SQL Server 2000
Deletes the specified maintenance plan.
Syntax
sp_delete_maintenance_plan [ @plan_id = ] 'plan_id'
Arguments
[@plan_id =] 'plan_id'
Specifies the ID of the maintenance plan to be deleted. plan_id is uniqueidentifier, and must be a valid ID.
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_delete_maintenance_plan must be run from the msdb database.
Permissions
Only members of the sysadmin fixed server role can execute sp_delete_maintenance_plan.
Examples
Deletes the maintenance plan created with sp_add_maintenance_plan.
EXECUTE sp_delete_maintenance_plan 'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC'
