我是否可以在每小时9点至下午6点之间的5个工作日内触发Azure数据工厂管道 [英] Can I trigger my Azure data factory pipeline in 5 working day between 9 am to 6 pm hourly

问题描述

我有一个Azure数据工厂管道，该管道可以加载每个工作日的数据(每个工作日运行).我想在工作时间(上午9点至下午6点)至每小时之间的每个工作日(周一至周五)触发管道.它应该每天在上午9点，上午10点，然后上午11点--------下午6点运行.我已经尝试过翻转窗口触发，但我认为它不支持触发间隔的时间段

I have a Azure data factory pipeline that load data of every working day(Run every working day). I want to trigger my pipeline every working day (Mon-Fry) between working hour(9am to 6pm) and hourly. It should run as daily at 9am then 10am then 11am--------at 6pm. I have tried tumbling window trigger but I think it does not support time period for trigger interval

推荐答案

ADF和Logic Apps中的重复模式不直接支持这种需求组合.当然欢迎您在ADF管道中尝试此操作，但是我发现Logic Apps对于此类操作要容易得多.以下是如何配置它的示例:

The recurrence patterns in ADF and Logic Apps don't directly support this combination of requirements. You are certainly welcome to attempt this in an ADF pipeline, but I find Logic Apps to be much easier for this sort of action. Below is an example of how you might configure it:

使用重复触发创建逻辑应用

在触发器"中，将频率"更改为天"并指定小时和时区:

In the Trigger, change the Frequency to Day and specify the hours and timezone:

计算星期几

使用以下表达式(更改为适当的时区)将星期几提取为变量:

Us the following expression (change to the appropriate timezone) to extract the day of the week into a variable:

dayOfWeek(convertFromUtc(utcNow(), 'Eastern Standard Time'))

这将返回一个整数，其中0 =星期日，1 =星期一，依此类推.

This will return an integer where 0 = Sunday, 1 = Monday, etc.

添加基于星期几的条件

使用dayOfWeek整数变量来确定要执行(或忽略)的日期.在此示例中，我出色的是第0天(星期日)和第6天(星期六):

Use the dayOfWeek integer variable to determine which days to act (or ignore). In this example, I'm exceluding days 0 (Sunday) and 6 (Saturday):

执行数据工厂

在True条件下，执行数据工厂(在False条件下不执行任何操作):

In the True condition, execute your data factory (do nothing in the False condition):

这篇关于我是否可以在每小时9点至下午6点之间的5个工作日内触发Azure数据工厂管道的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！