question

NagendraKumar-0445 avatar image
0 Votes"
NagendraKumar-0445 asked ·

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

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

azure-data-factory
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered ·

Hey @NagendraKumar-0445 ,
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

· 2 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@NandanHegde-7720 Thanks for the above alternate solution in order to achieve client requirements.

0 Votes 0 ·
NandanHegde-7720 avatar image NandanHegde-7720 NagendraKumar-0445 ·

@NagendraKumar-0445 ,
Glad I could be of help.

Can you please mark it as answer as this might be beneficial for other community members as well

1 Vote 1 ·