ADF trigger settings to skip weekends and first 3 days of the month.

Question

Requirements are:

1. Job should run only on weekdays.
2. Job should skip the run on the first three days of the month (1st,2nd and 3rd dates)

Problem:

1. Monthly Occurrence: In ADF trigger we have an option to skip the days on a month if we schedule monthly occurrence where it is not possible to skip the weekends
2.  Weekly Occurrence: On the other hand, we have option to skip weekends but dont have options to skip first 3days of the month.

Solutions tried: 

1. I have modified the JSON with monthDays <4 to 31> and weekdays  

Answer 1

@Manoj Vavikadai Parthasarathy

Thanks for using MS Q&A platform and posting your query.

Here are two possible solutions for scheduling the job to run only on weekdays, skipping the first three days of the month in ADF triggers:

Solution 1: Combining Monthly and Weekly Triggers

Create two triggers:

1. Monthly Trigger: Set the recurrence to "Monthly" and select the desired day of the week (e.g., Tuesday).
2. Weekly Trigger: Set the recurrence to "Weekly" with weekdays selected (Monday to Friday).

• In the "Conditions" section of the monthly trigger, add a condition that checks the day of the month. You can use an expression like dayOfMonth > 3 to ensure the trigger only fires after the 3rd day.
• The job will only run if both triggers fire:
• The monthly trigger fires on the desired weekday.
• The daily condition ensures it's past the 3rd day.
• The weekly trigger ensures it's a weekday.

Solution 2: Using a Custom Scheduler Script (More Complex)

1. Develop a custom script that checks the current date and day of the week. The script should only return true if it's a weekday between the 4th and the end of the month.
2. Use this script as the scheduling expression for your ADF trigger.

Here's why Solution 1 is recommended:

• It leverages existing functionalities within ADF, making it easier to implement and maintain.
• It's visually clearer in the trigger configuration compared to a custom script.

Hope this helps. Do let us know if you any further queries.