Solved

Using DTS and Scheduled Tasks to perform updates/deletes

Posted on 2002-05-29
3
191 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
Comment Utility
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
Comment Utility
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
Comment Utility
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.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now