hello, I have to add (timestamp '2018-01-16 16:30:00' and timestamp '2018-01-16 16:30:00' + interval '15' MINUTE) this condition in talend job, how to add this time interval in talend
I'm assuming you mean that you need to load the current system time and the system time plus 15 minutes using Talend.
Try this code in a tJava and see if it does what you want. If not, can you elaborate on your requirement a little?
Date now = routines.TalendDate.getCurrentDate(); System.out.println(now); Date nowPlus15 = routines.TalendDate.addDate(now, 15, "mm"); System.out.println(nowPlus15);
Write a job to get the data you want and set it to append 1 row to your CSV file for each run. Then schedule the job to run every 15 minutes (using crontab, a windows scheduler or Talend Administration Center if you have the Enterprise Edition).
If you want a Job to run continuously to do this, that is a bad idea with the ETL product. You could use the ESB product and have a Route running with a timer set to run every 15 mins. Then connect a cTalendJob component to the Timer to carry out the work I suggested in the paragraph above.
No. Not for scheduling. But I gave you some alternatives you could try. The ESB route may be tricky to get your head round, but it may open up a plethora of opportunities to you when you get to grips with it. Alternatively, use the crontab to do it (or a Windows scheduler).
I am trying to schedule a daily job for every 15 Minutes of time interval need to run. Could you please suggest me to configure a trigger every 15 Minute need to run ?
Please Help me.
For Windows you could try using the Task Scheduler (https://www.digitalcitizen.life/how-create-task-basic-task-wizard). For Linux you might try the crontab (https://tecadmin.net/crontab-in-linux-with-20-examples-of-cron-schedule/).
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables