Share via

Schedule Data Factory Trigger based on the Client Calender

Sukumar Vinnakota 316 Reputation points
2021-05-11T10:01:02.713+00:00

I have a requirement where My Data Factory must Trigger the pipeline on 7th Working day of Every Month. Is there any way we can import the Client/User defined calendar in Azure Data Factory for implementing the same.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,646 questions
0 comments
Accepted answer
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2021-05-11T10:15:13.993+00:00

    Hey @Sukumar Vinnakota ,
    Currently based on my understanding, there is no direct way to achieve it.

    you can follow the below process:

    You can create a lookup table with all the necessary dates containing the 7th work day of every month.
    Trigger the ADF on 7th, 8th, 9th ,10th and 11th of every month as 7th work day would definitely fall among these 5 days.

    within ADF have a lookup activity to compare whether the day on which the ADFs are triggered are equivalent to the lookup value from the table.
    If yes, proceed with other executions else exit.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.