sys.sp_delete_maintenance_plan_job

Description

Disassociates the specified maintenance plan from the specified job. This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Specifies the ID of the maintenance plan. Specifies the ID of the job with which the maintenance plan is associated. This stored procedure is used with database maintenance plans.

Syntax

sp_delete_maintenance_plan_job
[ @plan_id = ]
'plan_id'
, [ @job_id = ]
'job_id'
[ ; ]