Running failed steps

carumuga · June 12th, 2008, 07:03 AM

Hi,
I've scheduled a job, which has 10 steps in it. Out of 10 steps, the 4th step has failed and i would like to kick off the job manually originating from the failed step after correcting the issue. i.e. 4,5,6,7,8,9 and finally 10th step.

Your suggestion is highly appreciated.

Thanks,
Chandra

joefawcett · June 12th, 2008, 07:30 AM

If you use the SQL Server manager for 2005 you can right-click he job and choose the second option, Run job from step...
Not sure the 2000 manager has this ability.

--

Joe (Microsoft MVP - XML)

carumuga · June 12th, 2008, 08:08 AM

Basically the job is set up in SQL 2000, Is it possible to open the job from SQL 2005 and run?
Please advise on this. (I think, i can see the job but not the step in 2005)

Thanks,
Chandra

joefawcett · June 12th, 2008, 08:49 AM

I think it's possible, it seems to be okay on my machine here.

--

Joe (Microsoft MVP - XML)