Solved

Using DTS and Scheduled Tasks to perform updates/deletes

Posted on 2002-05-29
3
226 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

726 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