October 11, 2012 at 10:23 am
My client has a maintenance job that does way too much. I can fix that but in the meantime the job is failing everyday for the strangest reason. There is re-organize index task set to run on all databases. It's failing on this task. The error message says that it cannot find a certain object. It identifies the object and indeed this object does not exist. The problem is that this is a maintenance plan created by the wizard. It's just simply a re-org task with the all databases check-box checked. Now when I view the TSQL from within the viewer it actually shows the re-org code for the non-existent object. When I view the TSQL from the maintenance plan IS window the object is not present, as it shouldn't be.
It's like the plan has the code from when this particular object did exist. If I were to save the plan again, drop the job and recreate the scheduled job do you think it will fix this?
Thanks.
Joe
October 11, 2012 at 11:33 am
The issue sounds like the plan rather than the job. I would drop the plan and recreate, if its fairly standard you should be able to run the wizard. Or you could drop the step and re-create it, keeping the plan.
Before recreating the plan I would make sure SSMS on your client has the latest service packs installed.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply