Running Job Sequence within a Job Sequence

cdrk823 · Post by **cdrk823** » Tue May 31, 2005 1:11 pm

Hi everyone,

I know that these questions might be somewhere within this forum and I'm simply not using the right keywords to search, but here it goes anyway:

Is there a way to run a job sequence within a job sequence? The only thing I can think of now is to run it through a command activity via dsjob.

Is this advisable?

Would this affect performance?

If that sub-job sequence fails, would the main job sequence fail as well?

How would restarting the job work in this case?

Would restarting-completing the sub-job sequence then restarting the main job sequence from the breakpoint work?

Thanks in advance!

- cedrick

chulett · Post by **chulett** » Tue May 31, 2005 1:54 pm

A Sequencer is just another DataStage job, so you run them via the Job Activity stage like any other.

You have to propogate your sub-sequencer errors up to the parent sequencer via one of the 'Utility' routines - UtilityWarnToLog for instance - when any job in a sub-sequencer fails. The warning or failure in the sub-seqeunce itself can be noticed by the parent sequencer via Triggers.

cdrk823 · Post by **cdrk823** » Tue May 31, 2005 3:16 pm

sweet! I never thought of it that way. Thanks Craig!!