I am trying to create a flow which will run a stored procedure on an Azure database. When running the procedure on the server, it takes approximately 1 minute to complete. When I run it using either the SQL server or Azure Data Warehouse actions to Execute Stored Procedure, I get a timeout error.
Even though the settings say that the item is running asynchronously, it doesn't seem to have actually started the procedure as no data is updated on the server. I don't actually need a result set, so if it's possible to get it run truely async, that would do as a solution, or if I can get the timeout increased.
I have run a simple SQL statement (select getDate()) on the connection so there is no problem reaching or getting responses from the server.