Forum Discussion
Scheduling trigger hourly but only during the day
Hello, I'm new to this group but am hoping someone may have some words of advice for me. I'm building a web application that uses Power Automate and Azure Data Factory to do the hard work in getting all data from multiple sources into a single SQL database. It's all working quite well but I've just realised that my hourly triggers (part of the clients specification) are a bit wasteful as during the evening there's no new data coming from his operation. Essentially from 6:00pm until 6:00am the pipeline is just copying data that has not changed.
Does anyone know if it's possible to schedule hourly runs of the pipeline between certain hours of the day? I've seen the daily schedule that allows me to pick the days, but that only seems to facilitate one run per day at a specified time. I'm looking for something a little more dynamic than that.
Many thanks in advance!
Hi grantbeverley,
When you are creating a trigger, you can use the advanced recurrence option to specify exactly which duration it should execute. Please refer the link below for detail.
Regards,
Rajanand
- RajanandCopper Contributor
Hi grantbeverley,
When you are creating a trigger, you can use the advanced recurrence option to specify exactly which duration it should execute. Please refer the link below for detail.
Regards,
Rajanand
- grantbeverleyCopper ContributorThank you so much for taking the time to reply...and for solving my problem, I'm extremely grateful!!