title: Deleting records having a date older than 3 days, for rolling 3 day job?
body: <p>Prior to executing a sensitive sql command I wanted to do a sanity check.</p>
  
  <p>I am trying to delete records that have a [<code>LoadDt</code>] date value older than 3 days and my code is:</p>
  
  <pre><code>delete IntraDayStats
  where DATEDIFF(dd, LoadDt, dateadd(d,-3, getdate()) ) &gt;= 3 
  </code></pre>
  
  <p>I want to schedule this as a sql job so that my <code>IntraDayStats</code> table has a rolling 3 day history. The job will run nightly.</p>