Sequence - Trigger - OK/Warning
Moderators: chulett, rschirm, roy
Sequence - Trigger - OK/Warning
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.
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.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
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'.DSguru2B wrote:Look at Craig's 3'rd reply in thispost.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
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
No. If you think that is working for you - it's not. That "expression" evaluates to TRUE 100% of the time.sudharma wrote:DSJS.RUNOK OR DSJS.RUNWARN
You absolutely need to provide an expression - like "X = Y" - in order for it to resolve properly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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?
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?
<<<>>>
My opinions are just that.
My opinions are just that.
It's in the linked posts, but to bring it here:
stage_label meaning the name of the Job Activity stage to check.
Code: Select all
stage_label.$JobStatus = DSJS.RUNOK Or stage_label.$JobStatus = DSJS.RUNWARN
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I missed it, I apologize. Thank you!chulett wrote:It's in the linked posts, but to bring it here:
stage_label meaning the name of the Job Activity stage to check.Code: Select all
stage_label.$JobStatus = DSJS.RUNOK Or stage_label.$JobStatus = DSJS.RUNWARN
<<<>>>
My opinions are just that.
My opinions are just that.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: