schedule trigger from mid to end of each month

arkiboys 9,646 Reputation points
2023-04-01T16:42:56.8333333+00:00

hello,
how is it possible to schedule a trigger so that it runs from the 15th of till the end of the month?

for example:when we are in

january, it runs between 15th till 31st march
february, it runs from 15th till 28th feb
...

thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,702 questions
0 comments No comments
{count} votes

Accepted answer
  1. Suba Balaji 11,186 Reputation points
    2023-04-02T11:26:22.59+00:00

    Hi @arkiboys

    Thanks for the ask :)

    I guess, you could leverage the below setting, choosing last 15 days. If the calendar day comes, it will trigger, other it doesnt.

    Screenshot 2023-04-02 at 5.04.53 PM

    one another option is, schedule for the whole month, then use a if condition to check if current day >=15. If so execute activites, otherwise dont do anything.

    @greaterOrEquals(int(formatDateTime(utcnow(),'dd')),15)
    
    

    Let us know what do you think!

    BR

    2 people found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. Sedat SALMAN 13,180 Reputation points
    2023-04-02T10:55:11.7833333+00:00

    Here's a step-by-step guide on how to set up a trigger to run from the 15th to the end of each month:

    In Azure Data Factory, you can create a scheduled trigger with a custom recurrence to achieve this.

    1. Azure Portal > Data Factory. In the left-hand menu, click on "Author & Monitor" and then switch to the "Author" tab.
    2. Click on the "Triggers" button at the bottom of the page, and then click on the "New/Edit" button.
    3. "New trigger" > Under the "Start time" field, set the desired start date for the trigger (15th of the month)
    4. In the "Recurrence" section, set the frequency to "Month" and interval to "1".
    5. Click on the "Advanced" tab to expand the advanced settings.
    6. In the "End of the month" field, set the value to "True" to ensure that the trigger runs until the end of the month.
    7. Save the trigger by clicking on the "Finish" button.

    Now, your trigger will run from the 15th to the end of each month. However, since the number of days in each month can vary, you might need to create additional triggers or logic to handle edge cases like February with 28 or 29 days.

    For more complex scheduling scenarios, you can also consider using Azure Logic Apps to create custom schedules and trigger your Data Factory pipelines through the Logic App. This allows you to create more advanced scheduling patterns and conditions based on your requirements.


  2. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2023-04-03T21:19:03.2566667+00:00

    @arkiboys Thanks for using Microsoft Q&A forum and posting your query.

    Agree with Subashri Vasudevan solution and comments. You can just select the dates from 15th to Last of the month and it should automatically skip if there is no 31st in the month.

    Hope this helps. If Subashri Vasudevans response was helpful, please don’t forget to Accept Answer and click Yes for "was this answer helpful" as this can be beneficial to other community members.