Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Ven6
Contributor III
Contributor III

Send One mail

Good morning

I have a problem and ask for help.

I have a table with 04 fields (Name, First, DebutVaccance, FinVaccance, duree).

I have a job which consists of reading the data from this table, then lists all the lines where duree is >= 4. and e-mail them.

what I want is for the job to send only one email containing all the lines whose duree >= 4  

this is my job:

0693p00000AaaONAAZ.png

in tFlex_1 :

the difference between DebutVaccance and FinVaccance and store de result in duree.

0693p00000AaaNtAAJ.png

in tMap_1:

i sort the line that duree >= 4

0693p00000AaaODAAZ.png

in TJavaFlex_2:

I build de body of mail

0693p00000AaaO8AAJ.png

And send Mail in tSendMail

0693p00000AaaOIAAZ.png

plz help

Labels (2)
1 Reply
Anonymous
Not applicable

Hello,

 

Please try to use OnsubjobOk trigger instead of OnComponentOk. Let us know if it is OK with you.

 Best regards

 Sabrina