问题描述
执行存储过程是否可行,运行时间超过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
推荐答案
您可以查看以下内容。可以帮助您。
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上长时间运行的存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!