• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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.
0
ccleebelt
Asked:
ccleebelt
1 Solution
 
acampomaCommented:
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
 
ccleebeltAuthor Commented:
Thanks.  I will give it a shot.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now