Job Sequence - What could be the best design?

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
ushasunkara
Participant
Posts: 23
Joined: Wed Jan 18, 2006 10:43 am

Job Sequence - What could be the best design?

Post by ushasunkara »

Hello everyone,
First of all, thanks a lot for all the questions and answers on this site, really its very very helpful, thank you so much for everyone who 's giving their time to make this a wonderful site...

And coming to my question,
the scenario is something like this,
we've 4 jobs(parallel jobs), which are not dependent on each other,
jobA, jobB,jobC and jobD.

I need to have a sequence job now, having a condition, if samplefile1 is coming over, then job A should run,
if samplefile2 is coming over, then job B should run, samplefile3 - then job C....

Right now, i was thinking to put a nested condition -> (4 different ) job activities (which are jobA, jobB, jobC and jobD) -> all of them together linked to a Sequencer -> email notification...

Will this design be good? and how do i put an expression for this condition, in the nested condition to acheive this,
i ven't used Sequence much, so i'm really not sure,what to do,

please let me know, your ideas...
Thank you so much everyone...
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

The best way you could go about accomplising that is have a wait for file activity waiting for that file, have a link go out of it to JOBA,
similarly do this with all you jobs
make the links coming out of all those four job activities to a sequencer.
inside the sequencer, choose the mode as 'ALL'
from the sequencer have a link going to a notification stage.
thats the basic core,
you can also make it fancy by adding exception handlers
i hope that helps.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ushasunkara
Participant
Posts: 23
Joined: Wed Jan 18, 2006 10:43 am

Post by ushasunkara »

Thank you so much, atleast now, i m going good with the design part, but still not able to fix up loose ends, will let you know when i'm gettng stuck again in this design,
thank you so much once again for the basic core.
Usha...

DSguru2B wrote:The best way you could go about accomplising that is have a wait for file activity waiting for that file, have a link go out of it to JOBA,
similarly do this with all you jobs
make the links coming out of all those four job activities to a sequencer.
inside the sequencer, choose the mode as 'ALL'
from the sequencer have a link going to a notification stage.
thats the basic core,
you can also make it fancy by adding exception handlers
i hope that helps.
Post Reply