Can we trigger pipeline on first business day of each month to exclude holidays?

Question

Hi

Can we exclude public holidays to trigger Data Factory pipeline ?
If not can we achive in Logic apps so that I can call pipeline in a logic app?

Also, I want to consider day light saivings to trigger pipeline instead of UTC.

Thanks in advance.

Thanks

Answer 1

Hello @Kalyani Chakka ,
Thanks for the ask and using the forum .
You can use the below schedule something for the first business day of the month .

{"monthlyOccurrences":[{"day":"monday", "occurrence":1}]}  

For excluding the public holidays I dont think we have something for that . If you can add an array with all the public holidays and then use that in the IF activity , it should work that way . So on the public holidays days the actual pipeline will not execute all the activities .

For the day light saving question , not sure if you have read this

Thanks
Himanshu