How to get weekly and monthly schedule triggers to work in Azure Data Factory V2?

JonathanQuick-1666 30

Scheduling weekly or monthly triggers does not appear to work in Azure Data Factory V2, although hourly or daily works fine on the same simple test pipeline. All components have of course been Saved and Published.

Bhargava-MSFT 31,031 Reputation points Microsoft Employee

2023-12-19T18:42:16.53+00:00

Hello JonathanQuick-1666,

Welcome to the Microsoft Q&A forum.

Please check the status of your trigger and make sure it is not disabled. Also, check if the trigger is configured to run at the correct time and associated with the correct pipeline.

If this doesn't help, please provide the error message and the JSON of your pipeline so we can further diagnose the issue.

I hope this helps
JonathanQuick-1666 30 Reputation points

2023-12-20T10:40:10.9333333+00:00

The trigger is obviously enabled, saved and published, and configured to run at the correct time, and associated with the correct pipeline. I would hardly have posted the question if that were not the case.

The pipeline code is irrelevant since it runs perfectly well with a Daily trigger, but not with a weekly or monthly trigger. It is a simple test pipeline which assigns a value to a variable. There is nothing in the pipeline to diagnose.

Perhaps try reproducing the problem yourself in ADF Studio with a simple pipeline and a weekly or monthly trigger.

I will raise a support ticket in any case.
Bhargava-MSFT 31,031 Reputation points Microsoft Employee

2023-12-20T23:02:45.9333333+00:00

Hello JonathanQuick-1666,

Thank you so much for providing the additonal details. Yes, I was able to reproduce this issue from my end.

I have reached out to the Product team and will get back to you with an update as soon as I hear from them

Thank you for your patience.
JonathanQuick-1666 30 Reputation points

2023-12-21T15:25:45.1833333+00:00

That's great, thanks for your efforts so far.
Gupta, Dheeraj 0 Reputation points

2024-09-19T08:23:20.2266667+00:00

Can you explain the solution

Accepted answer

Bhargava-MSFT 31,031 Reputation points Microsoft Employee

2024-01-11T20:30:17.09+00:00

Hello JonathanQuick-1666,

Sorry for not getting back to you early.

The issue has been resolved.

I have tested and able to run the Weekly and Monthly scheduled triggers successfully.

If you encounter any further issues, please let me know.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Please sign in to rate this answer.

1 person found this answer helpful.
JonathanQuick-1666 30 Reputation points

2024-02-12T15:11:07.74+00:00

Thank for the update, can confirm weekly and monthly triggers working as expected.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to get weekly and monthly schedule triggers to work in Azure Data Factory V2?

0 additional answers

Your answer