topic Re: Run a job on a date condition in Talend Studio

Run a job on a date condition

Anonymous — Sat, 16 Nov 2024 14:20:11 GMT

Hello,
I need to run a job only when the current date is in month january.
I have seen that there is the tWaitForSQLData component but it only works on a reached nb of rows.
Could you give me some suggestions please.
Thanks

Re: Run a job on a date condition

Anonymous — Mon, 16 Jun 2008 13:28:12 GMT

You can maybe use the trigger Runif to the tRunJob component.

Re: Run a job on a date condition

Anonymous — Mon, 16 Jun 2008 13:53:35 GMT

Hello,
Set a variable with tSetGlobalVar :
key : "the_date"
value : TalendDate.getDate("MM")
Plug a trigger "run if" from the tSetGlobalVar to your job with this condition :
("06").equals(((String)globalMap.get("The_date")))
In this example the job will run if the current date is in month june.
JC

Re: Run a job on a date condition

Anonymous — Mon, 16 Jun 2008 14:45:52 GMT

Thanks very much.
The solution of jcoutin works very good.

Re: Run a job on a date condition

_AnonymousUser — Thu, 31 Jul 2008 09:58:44 GMT

Really working ..thanks

Re: Run a job on a date condition

Anonymous — Thu, 31 Jul 2008 10:30:18 GMT

Happy to be helpful.

Re: Run a job on a date condition

Anonymous — Tue, 05 Mar 2019 09:07:23 GMT

@jcoutin wrote:
Hello,
Set a variable with tSetGlobalVar :
key : "the_date"
value : TalendDate.getDate("MM")
Plug a trigger "run if" from the tSetGlobalVar to your job with this condition :
("06").equals(((String)globalMap.get("The_date")))
In this example the job will run if the current date is in month june.
JC

Thanks for the solution, I also need when the month is different. Instead of month equals to June I need month different from June. Can you help me?

Re: Run a job on a date condition

Anonymous — Tue, 05 Mar 2019 09:26:04 GMT

@haralba

Please add a not condition as a wrapper function.

Relational.NOT(true)

eg:- Relational.NOT(<your existing condtion>)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂