Can we trigger a pipeline on first business day of each month ? Do we have such option in ADF ?

Nagendra Kumar 31 Reputation points
2021-02-23T05:43:11.247+00:00

Can we trigger a pipeline on first business day of each month ? Do we have such option in ADF ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,533 questions
0 comments
Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP
    2021-02-23T08:17:34.71+00:00

    Hey @Nagendra Kumar ,
    Currently there is no in built ADF feature to allow job to run on 1st business day of each month.
    But that can be achieved by so other way as below:

    1. Create a lookup table in Azure SQL database with the list of all 1st business days of each month
    2. In ADF, create a lookup activity: Get the list of dates from the lookup table which is not processed and till date (i.e you do not want future dates and not the previously processed dates)
    3. You can schedule your ADF pipelines on first 3 days of the month as the 1st business day would be either 1st,2nd or 3rd calendar day in all scenarios.
    4. In case if your utcnow is equal to the value in the lookup table, then proceed with other tasks else exit
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest