I have a table of shopping baskets that contains a field called create date that I would like to somehow check and delete all baskets that have been abandoned for over two weeks.
Can I use a SQL DTS task for this to auto run each night and check. I already have it running to perform backups each night.
Please let me know and how this is possible, or if there is a better way. Thansk.