DSSendMailTester Rouitne

[prasad_chennai]

I am sending a email Notification in my one of my jobs whenever the Validation Fails( Like If we encounter with Null value then i am triggering a Email Notification).I am using the 'DSSendMailTester' routine in a Basic Transformer to achieve this functionality.

whenever the Null values occurs, i will send an email about the same with corresponding values in it.
Once i run this job with null values then it sending a email without any problem.After this, if i take a another run of the same without having null values in it then also its sending mail with the values of the previous Null Values (run).
But all the values loaded to the DB are good.
But unnecessary i am getting Multiple Email Notifications.
Please guide about this.what would be the problem?

Thanks,
prasad

[chulett]

Ugh. Why not write the bad vaules to a file, then send one email after the job completes if the file is populated rather than sending an email for every bad record?

[prasad_chennai]

I have proposed same what you said,but users want it like this only.for every bad record they need mail.

Code: Select all

 Oracle Source-------Transformer-----------Oracle target
                          |
                          |
                   Basic Transformer
                           |
                           |
                    Sequential File

I have mentioned IsNotNull(LNK.XXXX) function in Transformer stage.if i get null values, those are rejected into the Reject link.I am using stage varibles where i am calling DSsEndMailTester Routine.

These stage varibles will execute for every record and i will get the Mail Notification if reocrds are rejected to Reject Link.Normally its working Fine,but sometimes its sending duplicate mails for two consecutive Runs of Null value run and Non Null value data Run continuosly.

[ray.wurlod]

Prediction: user requirement will change once they start getting lakhs of emails from this process.