send email when job is run successfull

Six Stars

send email when job is run successfull

Hi,

I have designed a job to import data from MySQL, and scheduled it to run every 6 hour and every time it run I need to send a email . which is not a big issue. Now what I need is

Every time the job runs and successfully 0r fail completed . it should send a mail 

for the first run:

job_name|run_time|status

test_job,1,success:

for the second run:

job_name|run_time|status

test_job,2,success

job_name|run_time|status

test_job,3,Fail

 

and so on

 

Thanks,

Six Stars

Re: send email when job is run successfull

I could think of below solution . Not sure if it will fit with your requirement.
1) tLogCatcher --> tSendMail.

2) create a job to send mail and trigger it in job conductor based on a file trigger .
Main job can put trigger file so that eMail Job can be started for each run.

3) you can create execution Plan in TAC and execute job_sendmail based on main job sucess:Failure
Regards
Abhishek KUMAR

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.