Four Stars

how to send mail for tmap rejects

i am using tlogrow to capture tmap rejects. i want to send these rejected records through mail using tsendmail .

can you please suggest how this can be achived

 

sendmail.PNG

  • Data Integration
3 REPLIES
Nine Stars TRF
Nine Stars

Re: how to send mail for tmap rejects

Hi,
I suggest you not to send 1 email per reject.
Collect all rejects into a file then (onSubjobOk or at the end of the job using a tPostJob) send then email with the reject file as an attachment.
With this method you'll improve performance (1 email to send), you can design the reject file schema as you want and if necessary you can aggregate rejects from different steps of the job into the same file.
Hope this helps.


TRF
Six Stars

Re: how to send mail for tmap rejects

To add to above, you may create  a global variable to monitor the reject row count , after storing the error in file add a runif condition for counter>0 to to send the email

Four Stars

Re: how to send mail for tmap rejects

Hi thanks for that, can u please show how the flow would be