Auto purge

does any one know is there any feautres in MSDE that can do schedule and auto purge data?
Millions thanks
Hi
You can schedule a job using SQL Server Agent to call a stored procedure
which will purge the data based on the schedule.
If you have the Enterpsrise manager then you can do this using SQ Agent, New
Job .
If you do not have enterprise manager you need to create the job manually
using system procedures.
See books online for below procedures:-
sp_add_job
sp_add_jobschedule
sp_add_jobstep
Note:
You could also write a procedure to purg the data and use OSQL to call the
procedure. Save that command as a batch file and
schedule using windows schedular to run at specific time .
Thanks
Hari
MCDBA
"Devily" <Devily@.discussions.microsoft.com> wrote in message
news:A3D23D13-26E6-48AA-A6DD-4B706F823784@.microsoft.com...
> does any one know is there any feautres in MSDE that can do schedule and
auto purge data?
> Millions thanks