Cannot Delete Job

Question

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Have you tried deleting the maintenance plan linking to that job?

Nelson Viggiani-332216 Ten Centuries Points: 1264 More actions · Answer 2

there is NO Maintenance Plan, only a JOB, and I want to delete that job

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

I don't have 2005 installed here.

What have you found in the relations of the system tables?

Nelson Viggiani-332216 Ten Centuries Points: 1264 More actions · Answer 4

I found the problem.

the problema was on 2 table on MSDB database

1- select

* from dbo.sysjobs

2- select

* from dbo.sysmaintplan_subplans

I delete the job from table 2 and then right click on the job itself and delete and it go way...

works

thanks

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

You can delete directly in the system tables in 2005 ?!?!

Nelson Viggiani-332216 Ten Centuries Points: 1264 More actions · Answer 6

Ten Centuries

Points: 1264

January 31, 2007 at 7:59 am

Yes you can...

Tom Chantler SSC Enthusiast Points: 118 More actions · Answer 7

SSC Enthusiast

Points: 118

March 14, 2007 at 10:05 am

This information has just helped me. Thanks a lot!

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 8

Adiga One Orange Chip Points: 27284 More actions · Answer 9

Easiest approach would have been to delete the "Subplan" in the Maintenance Plan. The job would be automatically deleted.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga