Solved

Using DTS and Scheduled Tasks to perform updates/deletes

Posted on 2002-05-29
3
215 Views
Last Modified: 2006-11-17
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
Comment
Question by:ccleebelt
3 Comments
 
LVL 6

Accepted Solution

by:
acampoma earned 100 total points
ID: 7042776
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
 
LVL 6

Expert Comment

by:curtis591
ID: 7047837
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
 

Author Comment

by:ccleebelt
ID: 7051172
Thanks.  I will give it a shot.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question