Setting DSJS.RUNFAILED to DSJS.RUNWARN or DSJS.RUNOK

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
UPS
Premium Member
Premium Member
Posts: 56
Joined: Tue Oct 10, 2006 12:18 pm
Location: New Jersey

Setting DSJS.RUNFAILED to DSJS.RUNWARN or DSJS.RUNOK

Post by UPS »

I have created a DS job which completes with an error, and the error is allowed for this situation, but I'd like the stream to continue to the next job. Is there a way to change the JobStatus of a Job Activity from DSJS.RUNFAILED to DSJS.RUNOK?

This job is also called from a sequence, so since the job's status is in abort condition, the sequence also aborts. Is there a way for the sequence NOT to abort?

Any ideas on this are greatly appreciated.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

While you can't change one status to another, you can let the Sequence know it's ok by using the right triggers for the situation. What are you using now and do you have the "Automatically handle activities that fail" option enabled?
-craig

"You can never have too many knives" -- Logan Nine Fingers
kandyshandy
Participant
Posts: 597
Joined: Fri Apr 29, 2005 6:19 am
Location: Singapore

Post by kandyshandy »

Which one is your requirement?

if that job aborts, then you want to proceed to the next job

or

if that job succeeds or aborts, you want to proceed to the next job?

TRIGGER page of that job in Sequence allows you to have Executed OK, Failed, Warning options... Later you can have a sequencer stage on ANY mode.
Kandy
_________________
Try and Try again…You will succeed atlast!!
UPS
Premium Member
Premium Member
Posts: 56
Joined: Tue Oct 10, 2006 12:18 pm
Location: New Jersey

Post by UPS »

chulett and kandyshandy,
Thanks for the quick responses! The requirement is to have the job proceed to the next job, weather it's an abort or a success.
Disabling the "Automatically handle activities that fail" option worked! Thank you!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

If you need that "automatically handle" functionality for other parts of the Sequence, let us know. There are ways to work around the issue you are having with it and that one particular job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply