Blog Post

Azure Integration Services Blog
3 MIN READ

Execute a long running SQL Stored Procedure in Azure logic app using an Automation Account

Saroja_L_Sattigeri's avatar
Saroja_L_Sattigeri
Icon for Microsoft rankMicrosoft
Jan 21, 2022
When trying to execute a long running SQL query/stored procedure using the Logic App SQL Connector, you will most likely hit the 110 seconds execution timeout limit on SQL connector: SQL Server - Con...
Updated Jan 21, 2022
Version 1.0
logic apps
joelhtown80's avatar
joelhtown80
Copper Contributor
Aug 03, 2022

Hi Saroja_L_Sattigeri,

 

How do you do a batching of the results? When it only has few records, the output is shown:

But when I have about 100,000 records, then there is no output.