Auto delete records from database after some days

Question

I am developing website in asp.net. On some page we add data to database. But that data will be removed from database when its validity is over. I will provide date to data . The data is valid to that date. Please give me reply urgently.

Syed Shanu · Answer

Your question is not much clear . But i assume that you want to delete few records from your table after some days. lets consider that you have TableA in this table you can add a Status Column as deleteStatus by default to 'N' and after some days or you can have some logic to change the status for deleting rerecords to 'Y' Create one procedure . Check for the deletestatus='Y' record and delete that rows from Store Procedure. Create SQL JOB Agent .Add your Stored Procedure to job and set the intervel as every day or weekly one day like that.

Syed Shanu · Answer

Check this link http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/ In command textbox you have to paste your Stored Procedure. Other links http://www.mssqltips.com/sqlservertip/3052/simple-way-to-create-a-sql-server-job-using-tsql/ http://www.codeproject.com/Tips/620768/Create-New-Jobs-In-SQL https://mudassarkhan.wordpress.com/2009/01/13/job-schedular-sql-server-2000/

paresh gugale · Answer

how to create sql job agent & how to pass stored procedure to that