Disassociates the specified maintenance plan from the specified job.
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_job [ @plan_id = ] 'plan_id' , [ @job_id = ] 'job_id'
[ @plan_id =] 'plan_id'
Specifies the ID of the maintenance plan. plan_id is uniqueidentifier, and must be a valid ID.
[ @job_id =] 'job_id'
Specifies the ID of the job with which the maintenance plan is associated. job_id is uniqueidentifier, and must be a valid ID.
0 (success) or 1 (failure)
sp_delete_maintenance_plan_job must be run from the msdb database.
When all jobs have been removed from the maintenance plan, we recommend that users execute sp_delete_maintenance_plan_db to remove the remaining databases from the plan.
Only members of the sysadmin fixed server role can execute sp_delete_maintenance_plan_job.
This example deletes the job "B8FCECB1-E22C-11D2-AA64-00C04F688EAE" from the maintenance plan.
EXECUTE sp_delete_maintenance_plan_job N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC', N'B8FCECB1-E22C-11D2-AA64-00C04F688EAE';