dbTalk Databases Forums  

Dropping an Job

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Dropping an Job in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Greg
 
Posts: n/a

Default Dropping an Job - 11-17-2008 , 01:29 PM






I created a job to test the other day and now I want to delete/drop it. When
I choose the Delete option from Management Studio I get the following error.

Drop Failed for Job "Job Name"
The DELETE statement confliched 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.

What I'm trying to do is delete any Jobs I've setup for testing that I no
longer needs and to also delete any Maintenance Plans I no longer need.
Neither my Job or my Maintenance Plans are referring to any other jobs or
maintenance plans with them. Plus, they are very very basic items. All the
job does is it runs a Maintenance Plan at a certain time. That's it. All the
Maintenance Plan does is perform a backup of the database, that's it. Nothing
fancy is going on here.

After not being able to delete the Job, I went ahead and deleted the
Maintenance Plan and now I get a different error for the Job. It states:
Attempt to retreive data for object failed for Serverxxx failed. The Job
"Backup Name" does not exists on the server.

I don't quite understand what's going on here. All I simply want to be able
to do is create some simple test maintenance plans and jobs and delete them
when I'm done testing.

Thanks,

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.