title: How to run a stored procedure every day in SQL Server Express Edition?
body: <p>How is it possible to run a stored procedure at a particular time every day in SQL Server Express Edition?</p>
  
  <p>Notes:</p>
  
  <ul>
  <li>This is needed to truncate an audit table</li>
  <li>An alternative would be to modify the insert query but this is probably less efficient</li>
  <li>SQL Server Express Edition does not have the SQL Server Agent</li>
  </ul>
  
  <p>Related Questions:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/487675/how-can-i-schedule-a-daily-backup-with-sql-server-express">How can I schedule a daily backup with SQl Server Express?</a></li>
  <li><a href="https://stackoverflow.com/questions/287060/sheduled-run-of-stored-procedure-on-ms-sql-server">Scheduled run of stored procedure on SQL Server</a></li>
  </ul>