SQL Server, Error: 547 Maintenance Plan Error

Leave a comment (1) Go to comments

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)



An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)



Actions Required to Resolve this Error:

Type this command in your SQL server query box.

use msdb


select * from sysmaintplan_subplans

delete from sysmaintplan_subplans

It should work for you, as this solution has solved many user’s problem related to Maintenance Plan.


You can check out my Previous post

EOF - SQL Server, Error: 547 Maintenance Plan Error, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment


Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: