Triggers execution order in a Sequencer Job

[sumitgulati]

Hi,

I have a sequencer job that uses a RoutineActivity stage to make a lookup to a hash file. Based on the return value of the Routine Activity the subsequent jobs are triggered. One of the trigger conditions is like this:
If the return value is 'Y' then
-Move the source file to a bad files directory
-Send a notification
-Call UtilityAbortToLog to abort the sequencer.

All the above actions are performed in parallel if the return value is 'Y'.

RtnActivity
|--->Notification
|--->Move the source file to bad file dir
|--->Call UtilityAbortToLog

We noticed that whenever the ReturnValue from the hash file is 'Y' the UtilityAbortToLog gets executed first and hence prevents the execution of the other two triggers.

Is there a way I can set an order of execution of the triggers for a Stage in a Sequencer Job?

Thanks in advance
-Sumit

[chulett]

Use a single trigger. Link to the move activity and then to the notification and do the abort routine last. In other words, run them in a serial fashion, not in parallel.

[sumitgulati]

Use a single trigger. Link to the move activity and then to the notification and do the abort routine last. In other words, run them in a serial fashion, not in parallel.

Thanks Chulett. Actually we tried the same thing eariler but then we did not make the triggers unconditional. We now made the triggers unconditional and it worked.

Thanks
-Sumit

[ray.wurlod]

Triggers are executed in the order they are found in the grid, top to bottom.

For some strange reason this grid control does not support dragging rows to new positions, which most of the other grids in DataStage do.

All you can do is build the output links in the desired order of execution.
And submit an enhancement request through here (there's a special Forum) and/or your support provider.