Page 1 of 1

How to send a mail with file rejected with data

Posted: Fri Dec 21, 2007 4:25 am
by ysrini9
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

Posted: Fri Dec 21, 2007 6:47 am
by WoMaWil
yes

Posted: Fri Dec 21, 2007 6:50 am
by throbinson
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.