cannot-delete-job-the-delete-statement-conflicted-with-the-foreign-key

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 17, 2014 at 7:30 am

  #286668

  I'm trying to delete a job that was generated by a maintenance plan and I get the FK violation when attempting to do so.

  The article listed below describes the error but I did not see where it provided a solution.

  I have done this before but I do not recall the steps and tables involved.

  Any help would be greatly appreciated.:-)

  http://www.sqldbadiaries.com/2010/11/11/cannot-delete-job-the-delete-statement-conflicted-with-the-foreign-key/#

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• HanShi

  SSC-Dedicated

  Points: 33519

  More actions

  June 17, 2014 at 8:00 am

  #1722326

  Can you (or did you try to) delete the maintenance plan? As stated in the article:

  Now it is very simple. Just delete the maintenance plan. This maintenance had only one subplan, hence it was deleted. If it had more than one subplan, deleting the relevant subplan (Subplan_1 in this case) would delete corresponding SQL Server Agent job.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  June 17, 2014 at 8:37 am

  #1722347

  I deleted it and it worked.

  Last time I deleted it in T-SQL Code.

  Thank you.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/