Transact-SQL Reference

sp_delete_maintenance_plan

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'