Unable to delete job in sql server 2008r2

• Lian

  Right there with Babe

  Points: 754

  More actions

  January 23, 2012 at 11:38 pm

  #254048

  Good Day,

  I tried to delete a job created by the maintenance plan , but it displayed the message

  The "Delete " statement conflickted with the reference constraint "FK_Job_plan_id". Surely one should be able to delete jobs when needed . Is this a recognized bug in SQL Server ? This reminds me of SQL Server 2005 and one of the main reasons we are not using Maintenance Plans, but using our own scripts. Any ideas ?

• Gaurav Gosain-395499

  Right there with Babe

  Points: 770

  More actions

  January 24, 2012 at 3:21 am

  #1437553

  Check their may be other jobs associated with this job. try deleting maintenance plan instead of its job

  Thanks,
  GG;-)

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 24, 2012 at 5:11 am

  #1437587

  Check this.

  http://www.gudenas.com/2007/04/20/sql-server-2005-delete-maintenance-plan-error/

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  January 24, 2012 at 7:44 am

  #1437689

  :hehe:

  In my case it was aspnet_membership, and aspnet_usersinroles. From management studio, right click --> edit, and toward the bottom where it sets the constraints, add "on delete casecade" and execute just the alter. also, you will want to run the same thing with "on update cascade". This fixed my problem in no time flat.

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68154

• savethytrees

  SSCommitted

  Points: 1968

  More actions

  January 24, 2012 at 8:55 am

  #1437738

  You will have to delete some records from the sysmaintplans_subplan to delete the jobs. Take a look at this link

  http://saveadba.blogspot.com/2011/12/sql-server-msg-547-level-16-state-0.html

  Blog
  http://saveadba.blogspot.com/