Sequnce job

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
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Re: Sequnce job

Post by betterthanever »

did you use the "sequencer" stage so that you can kick - off second set of jobs after the parent jobs successful completion???
pimmit22043
Participant
Posts: 38
Joined: Thu Jul 26, 2007 6:11 am

Post by pimmit22043 »

all parent jobs are linked to " Sequnce stage " with "ALL" option and next sequnce stage with next set with "ALL" option.

when i run the sequnce all the jobs are starting same time ,including child jobs.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Something like this should do what you need:

Code: Select all

P1 ->            -> C1
P2 ->            -> C2
P3 ->  Seq (all) -> C3
P4 ->            -> C4
P5 ->            -> C5
Etc. Each job activity linked to a single Sequencer set to all, triggers from there to the next set of jobs. Lather, rinse, repeat.
-craig

"You can never have too many knives" -- Logan Nine Fingers
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Post by betterthanever »

it will not be case when "ALL" option is selected in the sequencer...
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What will "not be the case"? :?

"All" in a Sequencer means all input links must "fire" before anything passes out the other side.
-craig

"You can never have too many knives" -- Logan Nine Fingers
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Post by betterthanever »

i apologize chulett,
i was refering to pimmit22043 words


[b]all parent jobs are linked to " Sequnce stage " with "ALL" option and next sequnce stage with next set with "ALL" option.

when i run the sequnce all the jobs are starting same time ,including child jobs[/b][color=green][/color][/quote]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No worries, I question that statement as well. Seems like they aren't properly linked together, which is why I put up a little ASCII art. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
pimmit22043
Participant
Posts: 38
Joined: Thu Jul 26, 2007 6:11 am

Post by pimmit22043 »

Thanks Craig,

It works fine.

Thank you all once again.
Post Reply