title: Wait stored procedure execution until previous execution completes in SQL Server
body: <p>I need to execute a stored procedure in every 30 seconds. I register a method in <code>Application_Start(object sender, EventArgs e)</code> to run in every 30 seconds. This stored procedure takes long time to execute. The issue is whether the previous execution is completed or not the next iteration tries to execute the sp again. This causes some time out issues.</p>
  
  <p>Is there any way to wait for the previous execution get completed before executing the next iteration in sql server?</p>