title: Auto Delete Of Data From Database After A Fixed Time Interval?
body: <p>I am using <code>sql server 2005.</code> In my project i wanna auto delete the data from the <code>database</code> after a fixed interval of time say (10 minutes); Is there any  automatic process to  delete the data  from the <code>database</code> without the user intervention.. I want to use the <code>event scheduler</code> i have created a <code>event scheduler</code> but its not working any help ???</p>
  
  <p>this is the event i have created.</p>
  
  <pre><code>CREATE EVENT deletedata
  ON SCHEDULE 
  EVERY 10 MINUTE 
  DO 
  DELETE FROM user WHERE id=1
  </code></pre>