Running flows in a job in sequential order

rcdhawan · Post by **rcdhawan** » Thu Oct 11, 2007 10:07 am

I have three flows in a job:

1) MQ1->Transformer1->Sequential file1
2) MQ2->Transformer2->Sequential file2
3) MQ3->Transformer2->Sequential file3

My requirement is run 1), 2) and 3) in the sequential order. Run 1) and go to 2) only if 1) finishes and go to 3), only when 1) and 2) finishes. If they fail in the order, the job should fail altogether.

Please advise

chulett · Post by **chulett** » Thu Oct 11, 2007 10:36 am

Three jobs, run in a serial fashion via a Sequence job.

rcdhawan · Post by **rcdhawan** » Thu Oct 11, 2007 10:44 am

We cannot specify the order in the designer at all?

chulett wrote:Three jobs, run in a serial fashion via a Sequence job. ...

chulett · Post by **chulett** » Thu Oct 11, 2007 11:09 am

Not unless you can establish some kind of process break between them and thus link them together in one 'stream'.

rcdhawan · Post by **rcdhawan** » Thu Oct 11, 2007 6:03 pm

Can you please shed more light on this and 'stream'?

chulett wrote:Not unless you can establish some kind of process break between them and thus link them together in one 'stream'. ...

chulett · Post by **chulett** » Thu Oct 11, 2007 9:56 pm

Basically, this:

Code: Select all

MQ1->Transformer1->SequentialFile1->MQ2->Transformer2->SequentialFile2->MQ3->Transformer3->SequentialFile3

Perhaps read from a known empty file so that nothing is written to MQ but rather just serves as a process break...

Still think they should be three separate jobs, control the order and what happens when any given one fails by using a Sequence job.