Mail Alert

[kancherla_vijay]

Hi,

We are having a requirement in datastage parallel job, like a File will creted with 4 columns out of which one column is amount column. If the amount exceeds the value 100000 we need send an Email to the client.
Please let me know the approcah to solve this requirement.

Thnaks
Vijay

[ArndW]

Here's one approach of many. Call your PX job from a sequence, in the sequence have a transformer which has a constraint on an output link to only output when the value exceeds your limit and write this to a sequential file. Then, in the calling sequence check to see if the file has a length longer than 0 and if so add it as attachment to a mail.