在logicapp上长时间运行的存储过程 [英] Long-running stored procedure on logicapp

问题描述

 

执行存储过程是否可行，运行时间超过120秒？存储过程在Azure SQL服务器上执行。 

There is a posibility to execute stored procedure which will be running more than 120s? Stored procedure is executed on Azure SQL server. 

我发现有限制，我应该使用asyncPattern，但是如何在Azure SQL服务器上打开它？ ：） 

I figured out that there are limits and I shoud use asyncPattern, but how to turn on it on Azure SQL server? :) 

问候， 

Mike

Regards, 
Mike

推荐答案

Hi MIke，

Hi MIke,

您可以查看以下内容。可以帮助您。

You can probably take a Look into the below.May be it can help you.

https://connectedcircuits.blog/2018/07/04/using-logic-app-webhooks-to-execute-long-running-sql-queries/

https://connectedcircuits.blog/2018/07/04/using-logic-app-webhooks-to-execute-long-running-sql-queries/

它可以结合使用Web-hook API Connector和Azure Functions。

it can be done in combination of web-hook API Connector and Azure Functions.

这篇关于在logicapp上长时间运行的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！