Thursday, 2 June 2022

ADF Snack: Trigger every hour during office hours

Case
I want to trigger my ADF or Synapse pipeline every hour (or every 30 minutes) during office hours. How do I run my pipeline each hour without creating a separate trigger for each hour?
Don't want separate triggers for each hour















Solution
It is easier then you think. Create a new trigger and set Recurrence to Days and 1. Then just add one by one the number 8 to 17 under hours and 0 under minutes

Run pipeline each hour during business hours





































If you want it run each half an hour then just add 0 and 30 under minutes.
Run pipeline each 30 minutes during business hours