topic Re: Business Hour Pipeline Schedule in Pipelines

Business Hour Pipeline Schedule

bbrennan12345 — Sun, 14 Jul 2024 01:28:45 GMT

Is it possible to schedule a pipeline to run only during business hours? Pretty surprised this does not appear to be a default option under scheduling.

Thanks for any feedback!

Re: Business Hour Pipeline Schedule

NandanHegde — Mon, 15 Jul 2024 03:20:40 GMT

Can you please state here what you mean by scheduled during business hours only? Do you mean during weekdays specific time or is there something else?

Re: Business Hour Pipeline Schedule

Anonymous — Mon, 15 Jul 2024 05:50:42 GMT

Hi bbrennan12345 ,

Scheduling pipelines only during working hours is not a default option in Fabric Data Factory (FDF).
However, this can be accomplished with a few tricks and configurations. You can also use an external scheduling tool, such as Azure Logic Apps, to call the Fabric Data Factory's APIs to trigger pipelines to run at specific times.

You can refer to below document:

Overview - Azure Logic Apps | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Business Hour Pipeline Schedule

bbrennan12345 — Mon, 15 Jul 2024 18:40:29 GMT

Schedule as DAILY instead of HOURLY and you can set up to 10 specific times

Re: Business Hour Pipeline Schedule

bbrennan12345 — Mon, 15 Jul 2024 18:41:32 GMT

Thanks for the input. It turns out under the DAILY scheduling option you can select up to 10 specific options which can replicate what I was looking to do under the HOURLY function

Re: Business Hour Pipeline Schedule

Tom117 — Wed, 29 Jan 2025 18:48:05 GMT

"Scheduling pipelines only during working hours is not a default option in Fabric Data Factory (FDF)."

Why the heck not?

Re: Business Hour Pipeline Schedule

Subin — Tue, 18 Feb 2025 13:50:53 GMT

Got it. We can schedule the pipeline to run daily instead of hourly, and we can specify up to 10 different times within the day. However, my question is: What if we need to schedule more than 10 specific times?

For example, I need the pipeline to run every hour from 00:00 hrs to 23:00 hrs, which means 24 runs in a day. How can we achieve this?

Re: Business Hour Pipeline Schedule

Tom117 — Mon, 19 May 2025 18:33:37 GMT

Just so people can benefit from this.

If you need the ability to use behaviors similar to a CRON expression, create a notebook which when succeeds continues with your pipeline or if fails stops. I needed to run my pipeline once a day but only on weekdays. So in the notebook a grab the current date and fail if it's on a weekend.

I have no idea why MS hasn't implemented this basic behavior. Not to mention the lack of dark mode, which is absolutely unnacceptable. Anyway, that was my work around.