How to send a mail with file rejected with data

ysrini9 · Post by **ysrini9** » Fri Dec 21, 2007 4:25 am

Hi All,

I have a requirement like below:

Source --------Transformer------------>Staging
||

Rejectfile

If data is got aborted and loadted in to reject immedi..I need to send a mail to respective people ? attachment along with Rejected Rows ?

is there any possiblity to achieve in DataStage itself ?

Advance Thanks and Regards
srini

WoMaWil · Post by **WoMaWil** » Fri Dec 21, 2007 6:47 am

throbinson · Post by **throbinson** » Fri Dec 21, 2007 6:50 am

Call the job from a Sequence. Once the job completes, check the reject file in a Command Activity stage, if zero size you're done, if not then use a notification activity stage to send the e-mail with the Reject file attached.