Execute sql job step by step
-
can i execute a sql job step by step manually instead of running the whole job at once. I can do that in 2000 but cudnt find tht option in 2005.
-
The best you can hope for is to disable steps you don't want to run. You can change the start step, but everything after that will run so if you only want 1 step to run at a time, then you'll need to either disable the others or change the action to quit the job instead of moving to the next step.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
there is no option called disable step in 2005 we can just delete the step.
In sql 2000 was very gud in this regard for running each single step seperately, I dont know why its taken off in 2005.
-
Whatever step you want to run at a time....
on that step...
edit...goto advance tab...set following two options
on success action.....quit the job reporting success
on failure action.......quit the job reporting failure
-
Notice I didn't say there was an option called 'disable'. I just said to disable and then I went on to describe how to do that. But it's still disabling the steps.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply