Sequence Control question...

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Sequence Control question...

Post by kaps »

we design a sequence in such a way there are two job activities. Job Act2 starts at the successful comletion of Job act1. Job Act1 trigger is set to Success(goes to Job act2) and otherwise(goes to terminator activity).
I need to do the same for Job act2. I would like to fail the job even if there are warnings in Job act2.

Can I mention warnings on Trigger of Job act2 instead of Failed ? If I do that would the job fail for errors too or the job fails only for warnings?

Job Activity1-------->Job activity2
| |
| |
| |
| |
Sequence Collector--------->Terminator Activity

How can I accomplish this ? Please advise...
jwilliams
Participant
Posts: 10
Joined: Wed Aug 15, 2007 6:53 am
Location: Tennessee, USA

Post by jwilliams »

You should be able to run a link from your second Job Activity to either a Terminator or a Routine Activity that will abort and log the job failure. Once you have established a link, change the Expression Type of that link (found in the properties of that job activity) to "Warning".
Best,
J
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Use a dummy Command Stage to echo success, on the "OK" Trigger of Job_Act 2.
Second Trigger from Job_Act 2 to the Sequencer with trigger "Otherwise".
This way if there is anything other than "OK", it will get triggered.
Join the triggers from both Job_Act1 and Job_Act2 to the Sequencer (Any). This in turn feeds a Terminator.

HTH
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
kaps
Participant
Posts: 452
Joined: Tue May 10, 2005 12:36 pm

Post by kaps »

Thanks for the input.

I come up witha different way. Let me know if that's not correct.

I am planning to have two links from Job Act2 to Seq Collector.
One for failed and one for warnings. Now I can fail the jobs for both warnings and errors.

Let me know if you think this won't work.

Thanks
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

That should work too. Different ways to skin a cat!
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Post Reply