Reset a Job from a TRANSFORMER

MT · Post by MT » Mon Feb 23, 2009 7:15 am

Hi,

I searched the forum but I could not find a satisfying answer to following problem:

I run DataStage jobs with UtilityRunJob from a transformer but I run into problems if previous jobs (which where started via UtilityRunJob) aborted.
How can I reset a job from my TRANSFORMER stage (not from a script etc.) before "rerunning" it with UtilityRunJob?

Thanks in advance
MT

ArndW · Post by **ArndW** » Mon Feb 23, 2009 7:28 am

Although technically one can call a user-defined routine in a transform stage (either once as a before/after or for each row) that in turn can reset another job, it doesn't make sense to do so and I think that you should look at your design again.

A transform is called once a job is started, so in order to reach the transform the job must already have been reset; in addition you cannot reset a job that is running so it does sound like a catch-22 condition unless I have misunderstood what you are trying to do.

If you explain what you are attempting, perhaps someone could come up with a suggestion on how to do this correctly.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 23, 2009 2:23 pm

Prevention is better than cure. Write jobs that don't abort in the first place.

sachin1 · Post by **sachin1** » Tue Feb 24, 2009 1:09 am

As said earlier by Andrw and Ray, you can use a before job subroutine and code
ErrCode = DSRunJob(JobHandle , RunMode)
DSJ.RUNRESET Job is to be reset.

Reading help topics on DSRunJob can give you more idea.

Kirtikumar · Post by **Kirtikumar** » Tue Feb 24, 2009 4:20 am

Another option is create your own version of UtilityJobRun. In it, get the status of the job before calling DSRunJob. If needed, run the reset command for the job.