topic Re: Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule in Talend Studio

Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule

hgromek — Wed, 25 Apr 2018 13:59:20 GMT

HI, I have a Job that runs and grabs the last 7 days of data - emails it to me. When ran in TOS it is corrected. When I create the Bat file and run with Windows Task Scheduler it uses the last day it was ran in Talend as the Current Date and not the actual date ran.

Any suggestions on how to get the CURDATE in the mysql import query to use the actual date the task schedule is running?

Re: Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule

Anonymous — Thu, 26 Apr 2018 08:01:45 GMT

Hello,

Does your job work perfectly fine when you run your job script .bat file directly in cmd without using Windows Task Scheduler ?

Best regards

Sabrina

Re: Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule

hgromek — Fri, 27 Apr 2018 12:59:50 GMT

cmd does use the actual curdate - so it works through there! How do I get that to run a scheduled basis?

Re: Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule

Anonymous — Fri, 27 Apr 2018 14:04:56 GMT

I don't see why CurDate in mySQL would be affected by this. Maybe you could show us your code? But this solution will work for you. In a tJava at the beginning of your job, place this code....

globalMap.put("Date", routines.TalendDate.formatDate("yyyy-MM-dd", routines.TalendDate.getCurrentDate()));

This will store a correctly formatted (for mySQL) Date as String in the globalMap. Then in your MySQL query you can use it in the Where Clause like this....

"Select
Your,
Column,
Data
From Your.Table
Where yourDateColumn < '" +((String)globalMap.get("Date"))+"'"

Re: Talend Job, Runs with CURDATE() Doesn't get current date when ran with Windows Task Schedule

hgromek — Wed, 02 May 2018 13:30:32 GMT

My code used CURDATE directly in the sql. By doing the Java date, we are able to fins a solution that works! thank you for your assistance!