如何安排在Azure中数据工厂流水线 [英] How to Scheduling a Pipeline in Azure Data Factory

问题描述

我跟MS的教程，并创建了一个管道，从上premise SQL平板将数据移动到Azure的斑点，然后还有另一个管道BLOB数据移动到蔚蓝的SQL表。从文件规定，我需要指定活动期间（开始时间和结束时间）管线，运行良好的一切。

I followed the tutorials of MS and created a pipeline to move data from the on premise SQL Tablet to Azure Blob and then there's another pipeline to move the blob data to azure sql table. From the document provided, I need to specify the active period (start time and end time) for the pipeline and everything run well.

问题是我能做些什么，如果我想的管道进行每3小时启动，直到我手动停止操作。目前，我需要改变的开始时间和JSON脚本结束时间，每天再发布它，我觉得应该有另一种方式来做到这一点。

The question is what can I do if I want the pipeline to be activated every 3 hours, until I manually stop the operation. Currently I need to change the start time and end time in the json script and publish it again everyday and I think there should be another way to do it.

我是新来的蔚蓝，任何帮助/意见将是AP preciate，谢谢你。

I'm new to azure, any help/comment will be appreciate, thank you.

P.S。我不能这样做，因为我的导通premise SQL是在SQL2008谎称事务复制。

p.s. I can't do the transactional replication since my on-premise SQL is lied on SQL2008.

推荐答案

您可以设定无穷大管道的末尾：

You can set infinity as the end of the pipeline:

"end": "9999-99-99T12:00:00Z

和您的活动，增加

"scheduler": {
     "frequency": "Hour",
     "interval": 3
},

设置调度。我没有看到posibility手动停止管道（除重新启动）。

to set scheduler. I do not see posibility to manually stop pipeline(except restart).

这篇关于如何安排在Azure中数据工厂流水线的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！