Page 1 of 1

Timed "auto delete" from Database ?

Posted: Tue Feb 09, 2010 6:02 pm
by MiniMonty
Hi all,

I'm building a site where users will upload content which will only be relevant for a certain period.
Is there a way of setting an "auto delete" on the server / DB to remove the uploaded content after
say, 90 days ?

Best wishes
Monty

Re: Timed "auto delete" from Database ?

Posted: Tue Feb 09, 2010 6:20 pm
by JakeJ
Try a cron job and a stored procedure. Run it once a day. the SP will run a DELETE query on records more than 90 days old.