how can we reset a datastage job using datastage coding

[singhald]

Hi

I am using datastage job control to call some depandent sub jobs,before run I want to reset these jobs if these jobs having status stopped and abort . can somebody help me to find out code for this .

[pigpen]

dsjob -run -mode RESET ...

[kumar_s]

If you are using DsRunJob(), ther is a run mode DSJ.RUNRESET.

[singhald]

Hi
I am using this code to run a job using job control ,
so i need to put DSJ.RUNRESET instead of DSJ.RUNNORMAL, m i right. but if job is already in a runable state then below code will work or not ?

ErrCode = DSRunJob(hJob17, DSJ.RUNRESET)

[kumar_s]

DSRunJob(hJob17, DSJ.RUNRESET) Will reset the job. You need to use DSJ.RUNNORMAL to run the job again.
Reseting the finished job shouldnt be an issue, unless you expect to get its status. Perhaps you can check for the status and then you can reset.

[dsscholar]

I doing something exactly what you need..to check a job's status..if aborted/stopped..then reset..see if the code below helps..

* Check XXX JOBSTATUS. If the status is abort then reset the job before running
haddrr1 = DSAttachJob("XXX", DSJ.ERRFATAL)
Status = DSGetJobInfo(haddrr1, DSJ.JOBSTATUS)
If Status = DSJS.RUNFAILED Or Status = DSJS.CRASHED Or Status = DSJS.STOPPED Then
ErrCode = DSRunJob(haddrr1, DSJ.RUNRESET)
ErrCode = DSWaitForJob(haddrr1)
End
ErrCode = DSDetachJob(haddrr1)

[ray.wurlod]

Create a job sequence containing a job activity. Set the run property to "reset if required, then run". On the job properties window examine the code produced by compiling this job sequence. Emulate that code.

[lvidalfl]

Hi,

You can use the DSPrepareJob function, if the job is not ready to run, the function reset it before running.

VarX = DSPrepareJob(Job_Handler)

You have to use this function after you attach the job and before you run it.

I hope it helps.
Luis Vidal