DSXchange

Hi All,

I have 3 jobs running Sequentially in a Sequence.

The second job runs (parallel job) with acceptable warnings for the intial run. The consecutive runs will not have warnings for the same job.

I would like to specify in the Trigger
OK - (Conditional) or Warning - (Conditional)

How should i do that?

Thanks in Advance.

Look at Craig's 3'rd reply in thispost.

Hi Poorna,

Check for Custom conditional trigger and define your logic there.

IHTH

DSguru2B wrote:Look at Craig's 3'rd reply in thispost.

Actually, keep on going and read Ray's reply to my post. That was before I knew I should be using the DataStage constants like DSJS.RUNOK rather than the numeric equivalents like a '1'.

Yes, True, I forgot that these numeric values can change. Thanks for jumping in Craig.

Poorna,

Open your job activity in the sequence.
Go to the triggers Tab
on the job link, select expression type as Custiom (conditional)
and in the expression just specify this

(DSJS.RUNOK OR DSJS.RUNWARN)

this means that the jobs in your sequence will run even if they have any warnings or even if they run OK.

thanks
sudharma

poorna,

just specify without the brackets.


DSJS.RUNOK OR DSJS.RUNWARN


thanks
sudharma

sudharma wrote:DSJS.RUNOK OR DSJS.RUNWARN

No. If you think that is working for you - it's not. That "expression" evaluates to TRUE 100% of the time.

You absolutely need to provide an expression - like "X = Y" - in order for it to resolve properly.

I have the same question. I looked over the post that was linked, but I either do not fully understand or I am having trouble translating into a single Job Sequence, rather than a sequence of sequences.

My Job Sequence is 3 jobs executed in serial, each of the subsequent jobs can run on an "Executed OK" or "Execution finished with warnings" from the previous.

As chulett said, DSJS.RUNOK OR DSJS.RUNWARN does not work. Does someone have a Custom (conditional) that does work?

It's in the linked posts, but to bring it here:
stage_label meaning the name of the Job Activity stage to check.

chulett wrote:It's in the linked posts, but to bring it here:

Code: Select all

stage_label.$JobStatus = DSJS.RUNOK Or stage_label.$JobStatus = DSJS.RUNWARN

stage_label meaning the name of the Job Activity stage to check.

I missed it, I apologize. Thank you!

Or We can do this, by specifying custom condition as
Activity variable.$jobstatus <= 2

Unsafe. Job status values can be negative if internal errors occur.