schedule trigger from mid to end of each month

Question

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

Answer 1

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.

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

Answer 2

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.

Answer 3

@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.