Droping a Maintenance Plan

• kd11

  Hall of Fame

  Points: 3447

  More actions

  June 11, 2012 at 8:04 am

  #259233

  Is there an easy way to drop a maintenance plan job? when doing it via SMO right clicking & selecting delete, I'm receiving 547:

  errorTITLE: Microsoft SQL Server Management Studio

  ------------------------------

  Drop failed for Job 'XXXXXX.Subplan_1'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Job&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

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

  ------------------------------

  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 DELETE statement conflicted with the REFERENCE constraint "FK_subplan_schedule_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'schedule_id'.

  The statement has been terminated.

  The statement has been terminated. (Microsoft SQL Server, Error: 547)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=547&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

• matt.newman

  Hall of Fame

  Points: 3910

  More actions

  June 11, 2012 at 1:37 pm

  #1499476

  You still want to keep the maintenance plan but not the job associated? What is the overall goal?