How to set CRON trigger to run the job on 1st working day of month?

[Sparta_123]

I want to set a CRON trigger for Talend job on TAC which will execute on 1st working day of month.

[Anonymous]

Hi,

    You will have to select the original cron to run for 1 to 7 of every month. Now, you need to store the list of holidays in a table / file. The first activity will be to go and check the table whether there is an entry for that date. If its there, exit the job else proceed to actual tasks.

   After the task is over, add an entry to another table to capture the last processing time. Next time when the job is getting triggered, it should go to this table also and check whether it was processed for same month. If yes, exit else proceed further (I did not tell it in previous paragraph so that you will get to know what I am trying to do). This activity also need to be added at the beginning of the flow.

Since the holidays differ from country to country, there is no direct mechanism to trigger at the first working day. Hope you got the logic.

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