MSSQL record date/time auto delete

SQL Server Agent can do this for you.

Simply create a job with a regular schedule and the SQL you want to run. There is an easy to use wizard interface for job creation.