Sql server 2008r2

Question

Hi All I want to truncate table automatically after five days

Lakshmanan Sethu · Answer

Hi Ravi Please chk this http://sqlmag.com/blog/truncating-sql-server-job-history

Anupam Singh · Answer

Hi Ravi You can create job in SQL Server and schedule it for this type of scenario. Refer this article written by rajkumar : http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/