Drop failed for Job ‘XXXXXXXXXXXXX’. (Microsoft.SqlServer.Smo)

drop failed job ‘xxxxxxxxxxxxx’. (microsoft.sqlserver.smo)

the delete statement conflicted reference constraint “fk_subplan_job_id”. conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’.
the statement has been terminated. (microsoft sql server, error: 547

you can delete job , maintenance plans manualy tsql.
here sql fix this: http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/

 

--note: replace “maintenanceplan” 
    use [msdb]    declare @job_name varchar(100)    set @job_name = n’maintenanceplan’        --first, delete logs plan    delete sysmaintplan_log    sysmaintplan_subplans subplans inner join    sysjobs_view syjobs on subplans.job_id = syjobs.job_id inner join    sysmaintplan_log on subplans.subplan_id = sysmaintplan_log.subplan_id    (syjobs.name = @job_name)        --delete subplan    delete sysmaintplan_subplans    sysmaintplan_subplans subplans inner join    sysjobs_view syjobs on subplans.job_id = syjobs.job_id    (syjobs.name = @job_name)        -- delete actual job     delete  msdb.dbo.sysjobs_view name = @job_name        

SQL Server  >  Getting started with SQL Server