Blog, Power Automate
How to use Azure Elastic Jobs to deal with long-running SQL Stored Procedures triggered from Logic Apps or Power Automate
SQL Server connector in Power Automate & Logic Apps has 110 second timeout for queries. You can get around this limit via Azure Elastic Jobs.