ADF Trigger Schedules

Question

Can we schedule the trigger for once in last working day of the month?

Answer 1

Hi @M, Pratibha
Azure Data Factory does not natively support scheduling a trigger on the "last working day of the month". A Schedule Trigger can only be configured for the last calendar day of the month using monthDays: [-1].

If your requirement is the last working day (excluding weekends and/or holidays), a common approach is to:

• Schedule the trigger to run on the last few days of the month (for example, 28–31), or on the last calendar day using monthDays: [-1].
• Add logic within the pipeline to determine whether the current date is the last working day.
• If holidays must also be considered, maintain a holiday calendar (for example, in a table or file) and validate against it before proceeding.

Therefore, this requirement cannot be achieved using an ADF Schedule Trigger configuration alone; additional pipeline logic is required.

Answer 2

Hi @M, Pratibha

In ADF Studio having option to trigger your pipelines. attached screenshot for your reference.

Thanks.

Answer 3

Yes, but not directly as “last working day of the month” in one setting.

Schedule triggers in Azure Data Factory support:

• monthDays with negative values, for example:

    {"minutes":[0], "hours":[6], "monthDays":[-1]}
  

  This runs at 6:00 AM on the last calendar day of each month.
• monthlyOccurrences for patterns like “last Friday of the month”, for example:

    {"monthlyOccurrences":[{"day":"friday", "occurrence":-1}]}
  

  This runs on the last Friday of every month at the specified start time.

To approximate “last working day of the month”, configure a monthly schedule that matches the business rule, for example:

• Last Friday of the month → use monthlyOccurrences with {"day":"friday", "occurrence":-1}.
• Last calendar day of the month → use monthDays:[-1] and handle weekends/holidays inside the pipeline logic if needed.

---

References:

• Create a trigger that runs a pipeline on a schedule
• Pipeline execution and triggers in Azure Data Factory or Azure Synapse Analytics