Trigger file

rajudx · Post by **rajudx** » Mon Aug 18, 2008 1:56 pm

Hi,

I need to create one Trigger file for that I have designed the job like below.

db2 stage----------->Transformer--------------->Target file.
--------------->Trigger file(Zero byte)

My requirement is whenever target file is created successfully than only creation of trigger file will be required.
Please let me know what constraint I have to write in transformer stage.

Thanks,
Raju.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 18, 2008 2:58 pm

Welcome. :D

Use ExecSH as an after-job subroutine to create the trigger file (for example using echo > #TriggerFile# as the command). There is a check box "only execute after-job subroutine if job successful" - check that.

chulett · Post by **chulett** » Mon Aug 18, 2008 3:15 pm

Nice. The important thing to realize is no constraint will fulfill the requirements and even adding an aggregator for a 'last' trigger would not guarantee 'only on successful creation'.