title: Run Azure SQL Server Stored procedure async
body: <p>I am moving from an onprem SQL Server managed instance to a Azure SQL Database. My issue is that given the lack of a Sql Agent I am forced to run a Azure Function to automate some stored procedures that we`re running.</p>
  
  <p>Here is the issue:</p>
  
  <ol>
  <li>Azure Function cannot run more than 10 minutes (without a big hassle) my archiving job runs for about 40 minutes.</li>
  <li><code>sp_start_job</code> - does not exist in Azure SQL</li>
  <li>Trying to find a way to not keep open the connection from Azure function.</li>
  </ol>
  
  <p>Thanks in advance all help is appreciated</p>