DSXchange

Can someone tell me what actually happens when we reset the DataStage job ? Does it only erase the check point information in seqence jobs or does it do anything more ?

what happens when we do log reset ? I see a event type called DSJ.LOGRESET. Is there any similar command to run from command line ?

Thanks

Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state.

thanks,
Tom

dwandbi wrote:Resetting .........brings back the job in a stage to be able to recompile the job.

Hi dwandbi,
The first part of your answer implies that when a job is reset, it gets to a "ready to be recompiled" state. Meaning, one should recompile the job to run it again.

dwandbi wrote:Hence by resetting the job, we are able to bring back the job in a runnable state.

The latter part seems to imply that when the job is reset, it goes into a runnable state. Meaning the job does NOT need to be recompiled in order to run again.
Can you clarify?

Thanks,
gateleys

Both statements are correct. Resetting a job puts it back to a runnable state, no recompile needed. Aborted jobs must be reset before they can be recompiled.

Stopped jobs also must be reset before they can be re-run.

dwandbi wrote:Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state.

thanks,
Tom

Compilation does not require the job to be in runnable state. Unless the job is running, it can be compiled at any state.

DSJ.LOGRESET is a constant for selecting log events of type "job has been reset" using DSGetNewestLogId(). It is not a command.