Possible to add DB entries that expire?

Forum Moderators: open

Message Too Old, No Replies

2:33 pm on Oct 8, 2007 (gmt 0)

Is there a way to insert a DB row that expires (i.e. deletes) after a set time.

I'm looking for a quick way to free my DB of outdated entries. Or do I need to use something like a cron job for periodic deletes?

10:16 pm on Oct 8, 2007 (gmt 0)

Cron job or agent is the usual way. You could create an additional step in the backup proc.

11:23 pm on Oct 8, 2007 (gmt 0)

Thanks.