you can not do this using SQL. You will have to either schedule a job to do this or create a Windows Service which will fire the delete query every half-an-hour