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/).
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.