Forum Discussion

grantbeverley's avatar
grantbeverley
Copper Contributor
Nov 19, 2023

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.

    https://ibb.co/s3p81xv

     

    Regards,

    Rajanand

  • Rajanand's avatar
    Rajanand
    Copper 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.

    https://ibb.co/s3p81xv

     

    Regards,

    Rajanand

    • grantbeverley's avatar
      grantbeverley
      Copper Contributor
      Thank you so much for taking the time to reply...and for solving my problem, I'm extremely grateful!!

Resources