Example: Reading email addresses from a table and sending an email to each person
In this example, a table stores the email information.
| mpey@talend.com |
| shon@talend.com |
| lgaus@talend.com |
| ... |
The request is to read the email addresses from the table and send an email to each person with a tSendMail. But, as this table may contain invalid emails, the Job stops once an invalid email is sent to the tSendMail if you put all the components in one Job. To achieve this request, design the Jobs as follows.
- The tMysqlInput_1 component reads emails from the table.
- The tFlowToIterate_1 component iterates each email.
- The tRunJob_1 component calls the child Job.
- The tSendMail_1 component sends an email to each person.
- The tLogCatcher_1 component catches the Java exception and log it into a table via the tMysqlOutput_1.