Fetch data using Iterate and send logs by mail

[Anonymous]

Using below Job  Oracle Input-->Iterate ---> Sending Mail   to multiple mail ids , now i need to send logs of all the users to whom mail has been sent in single mail .Can you help me how can same be achieved .

something like below 

Oracle Input-----Iterate----SEndng Mail---Log----Sendmail(log file with all details as attachment) 

[Anonymous]

one easy way to accomplish this is to copy and paste your original query/send mail part and simply remove the iterate to gather all rows into a single email message.

[Anonymous]

JGM i can do that , but then 1 by 1 mail wont' go to user .

Overall first i need to fetch records 1 by 1 and send mail using iterate and then i need to send all those records by mail to users for there information that mail to all these users has been sent .

[Anonymous]

can any one guide me on this 

[Anonymous]

Hi,

     Could you please try below way?

  Since we are using On component ok, it will allow the trowgenerator to push records to target file each time. Please fix 1 record in trowgenerator and select append option in the delimited file. 

   I have added a tSleep to make sure that we will give some 10 to 20 seconds delay to complete writing the last record to file.

   You can use tSendmail to publish the file which will have details of all the records for whom mail was sent.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

Nikhil thats great but can you give me how can i populate  field using trowgenerator ,eg. i have 1 value as emailid coming in frm DB and getting passed to sendmail how can i capture same in trowgenerator and then to outputdelimited .  Thanks for your response and guidance 

[Anonymous · Accepted solution]

Hi,

    Could you please try to add the column value from tflowtoiterate? Also set the number of records in trowgenerator as 1.

Hope it will help you to resolve your use case 🙂

Warm Regards,

Nikhil Thampi

[Anonymous]

Kudos Nikhil Work like a Charm