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
DSSendMailTester Rouitne
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
-
- Participant
- Posts: 38
- Joined: Wed Jul 18, 2007 12:23 am
- Location: Chennai
I have proposed same what you said,but users want it like this only.for every bad record they need mail.
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.
Code: Select all
Oracle Source-------Transformer-----------Oracle target
|
|
Basic Transformer
|
|
Sequential File
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: