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

Kalyani Chakka 1 Reputation point
2020-11-12T00:00:38.907+00:00

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

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,088 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,568 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2020-11-13T00:44:13.207+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.