Create an SP which uses the xp_cmdshell and use the del command along with it.

Call the SP through a SQL agent job. Schedule the job for daily run.