Hello
I am using SQL Server 2005
I want to delete the data from my table after specific number of days.
This should happen automatically.
After the days I specified the data from the table should automatically get deleted. Can anyone let me know how to achieve this.
If anyone can give an example for this it will be great.
Thanks in advance.
Hi,
As the title of your post suggests you've already identified that you need a job running on the server to facilitate this.
SQL Server Agent will allow jobs to be scheduled and run - read up about this feature of SQL Server if unsure.
As for how to add a job...
In SQL Server Management Studio connect to the server.
No comments:
Post a Comment