ADF Trigger Schedules

M, Pratibha 0 Reputation points

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

0 comments No comments
Sign in to comment

Answer accepted by question author

Pilladi Padma Sai Manisha 10,190 Reputation points • Microsoft External Staff • Moderator

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.

  1. M, Pratibha 0 Reputation points

    Thank you for the clarification @Pilladi Padma Sai Manisha

Sign in to comment

2 additional answers

  1. Senthil kumar 685 Reputation points

    Hi @M, Pratibha

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

    👁 User's image

    Thanks.

    0 comments No comments
    Sign in to comment

  2. AI answer

    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:

    AI-generated content may be incorrect. Read our transparency notes for more information.
Sign in to answer

Your answer