Tag Archives: Microsoft SQL Server

SQL Server, Error: 547 Maintenance Plan Error

I was ‘trying’ to delete an obselete SQL Server Agent job until this nice error popped up: The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column ‘job_id’. The statement has been terminated. (Microsoft SQL Server, Error: 547)   Drop failed for Job ‘MYMAINTENANCEPLAN.Subplan_1′.  (Microsoft.SqlServer.Smo) —————————— ADDITIONAL [...]