Automatic Procedures 1

[abienz]

Hi there I need a little help in running an automatic task on a SQL Server 7 DB.
I have a table that is constantly being updated, everytime a row is added it gets a time stanp to it.

What I would like is to create a stored procedure (or such like) that checks the table once a night and removes all data that is over 30 days old and exports it to another similar table.

That way I'll have the table that is being constantly being updated kept with fresh data, and another table that can be used as an archive for the old data.

I've heard something about DTS but haven't managed to find much information about this, is there a swift solution to this problem?

 

[rajeevnandanmishra]

Hi abienz,
Create a procedure which delete/ archive data from your table And then schedule it through the enterprise manager. And if you face any problem, please let us know.