How to trigger a Talend job based on the mysql insertion/updation

[_AnonymousUser]

Hi All,
How to trigger a Talend job based on the mysql insertion/updation on a particular table.And Talend job will fetch those new/updated records and sync those into another database.
Can any once please suggest me on this.

[soujanyam]

Hi Sabrina,
Thanks for your reply
Ya I export the job and scheduled it with  crontab command as mentioned in forum.But I couldn't see the output.
And whem used crontab -l command I could not get list of scheduled job. It means My job scheduled or not.
1)If scheduled so where my output will be stored?
2) I actually wants to update the job output...Is it works?
Thank you

[Anonymous]

Hi Metta Soujanya,
Is your exported job working well when you execute .sh file directly in linux? Is there any update in your MySql table?

Best regards
Sabrina

[soujanyam]

HI Sabrina,
Thanks for reply
I execute .sh file (the exported job file) using crontab -e command and there is no update in my output
Note:I used tFileOutputDelimited, I'm not yet used tMysqlOutput(update/insert).

[Anonymous]

Hi,
Is everything going well in studio(update works well)? Do your new file has the same schema structure with existed one? Would you mind uploading your processing workflow screenshots into forum so that we can see if your workflow works normally(all files can be listed by tfilelist).
Best regards
Sabrina

[soujanyam]

Hi Sabrina,
My new file has the same schema structure with the existed files.
All files listed into the tFilelist only and used append also in tFileOutputDelimited.
If I run my job directly in the Talend studio I would get the output but while executing by job scheduling, could not get.
(Iam trying on sample files before directly trying on real time data)
Please solve my problem as soon as possible so that I'll work on real time data.

[Anonymous]

Hi,
If job works well in studio, the work flow is correct. Is there any error info printed on commandline when execute exported job.sh file? What's your JDK version in Ubuntu OS?
Did you follow up document TalendHelpCenter:How+to+build+Jobs to export your job script? We cannot open the screenshot link you provided. Could you please check it?
Best regards
Sabrina

[soujanyam]

Hi Sabrina,
In comand prompt also not getting any error. I used command in crontab as
8 16 23 7 2 /home/Desktop/SAMPLE_run.sh
And after when used command crontab -l,it shows like follows
# m h  dom mon dow   command
8 16 23 7 2 /home/user/SAMPLE/SAMPLE_run.sh
Does it scheduled or not?
I have to done my work by tomorrow..I'm trying a lot thats why posting in different links for your help.
Thank you.

[soujanyam]

I followed Talend Help Center Exporting+a+Job+script+and+executing+it+outside+of+Talend+Studio) to export my job and schedule. Even though I'm unable to get output.
One thing, there is no option like  current time stamp in tInputDelimited Built In settings as mentioned in the tFixedFlowInput. 
Please provide the solution
Thank you

[Anonymous]

Hi Metta Soujanya,
What's your JDK version in Ubuntu OS? Regardless the cron trigger tool, is your .sh file working well for you(execute it directly without cron tool).
Best regards
Sabrina

[soujanyam]

My JDK version is "1.7.0_60". I execute .sh file using following commands

cd /path/to/file
chmod +x filename.sh
./filename.sh

It is not working well,error occuring.
Thank you.