SQL Server Performance Forum – Threads Archive
Automatic deleteHey all, I am a noob. I have 1 table that needs to have records deleted from it when the "ExpiryDate" field is past the current date/time. This automatic delete needs to happen once every hour. What would be the best way to approach this? THANKS!!!
I would create a simple delete statement and put it in a job that runs every hour. This would take care of it quite simply Chris
Thanks Chris! Are there any links you know of that can give me some example code on this to get me started. Thanks!
delete table_name where column_date <= Getdate(). You can run a schedule job each our (Entreprise Manager, New Job, Schedule). Luis Martin
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.