title: SQL Server Execute Query Every Interval
body: <p>I would like to execute a query in the Management Studio every 3 seconds for monitoring/maintenance needs. I know I can define a job or use an external application. But I 'm looking for something much simpler. Something like the following pseudo:</p>
  
  <pre><code>DECLARE @Interval INT
  SET @Interval = 3000 -- I'm expecting milliseconds
  BEGINLOOP (@Interval)
      SELECT * FROM MyTransactions
  ENDLOOP
  </code></pre>
  
  <p>I would like the output to refresh every 3 seconds. Is that possible?</p>