<div>
Hi,<br />
<br />
My suggestion is for you to drop the constraint &quot;FK_subplan_job_id&quot; first before you delete the job.
</div>


Hi,

My suggestion is for you to drop the constraint "FK_subplan_job_id" first before you delete the job.

<div>
I do not understand the use msdb. Where do I access this?
</div>


I do not understand the use msdb. Where do I access this?

<div>
<div class="content wysiwyg-content">
I ma unable to delete an SQL maintenance job (SQL 2005). Error is The DELETE statement conflicted with the REFERENCE constraint &quot;FK_subplan_job_id&quot;. The conflict occurred in database &quot;msdb&quot;, table &quot;dbo.sysmaintplan_subplans<wbr />&quot;, column 'job_id'.<br />
The statement has been terminated. (.Net SqlClient Data Provider)
</div>
</div>


I ma unable to delete an SQL maintenance job (SQL 2005). Error is 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. (.Net SqlClient Data Provider)

can't drop sql job

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.