Using DTS and Scheduled Tasks to perform updates/deletes

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.
ccleebeltPresidentAsked:
Who is Participating?
 
acampomaConnect With a Mentor Commented:
You can simply set up a job with an SQL script to run and do this.
Create a job,
Add a step
set transact SQL as type
enter your sql in the command box
and then create a scedule for it

0
 
curtis591Commented:
You could use a sql task inside of your dts package or you could the job scheduler like acampoma is talking about.  If you use the job scheduler.  Either way would work it just depends how you want to manage all you scheduled jobs.
0
 
ccleebeltPresidentAuthor Commented:
Thanks.  I will give it a shot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.