title: How to force the infinite while loop script to stop in sql server agent jobs
body: <p>I created the following job to run the stored procedure every 5 second in the Sql Server Agent. I tried to stop the job but the script seems still running. Is there a way that I can stop the job?</p>
  
  <pre><code>WHILE 1=1
  BEGIN
       execute sp_TPAC_ETL_Create_Stamping_Transactions
  WAITFOR DELAY '00:00:05.000';
  END
  </code></pre>