Page 1 of 1

control the Execution flow

Posted: Wed Jul 21, 2010 4:04 am
by nagarjuna900
Hi,

I have two job flows ( One flow for inserting the table, second job for updating the table) in single workspace window in designer.

I need to run the first the first job ( for insert) and Update flow ( for update).

How to fix it.

Many thanks,

Posted: Wed Jul 21, 2010 4:26 am
by Sainath.Srinivasan
I assume by 'single workspace' you mean same job. Also am assuming that it is quite complex to redesign from scratch.

Easiest way will be to copy-and-paste them into two separate jobs.

Alternatively you can insert a dependancy by inserting a dummy lookup of data from input stream in the update stream which will cause a delay of the update stream.