delete data from database after Specified day in asp.net

Create following stored Procedure and call it daily using Sql Job.

CREATE PROCEDURE [dbo].[DeleteData] ASBEGINSET NOCOUNT ON;
DELETE FROM Advertisment
WHERE CONVERT(DATE, GETDATE()) = CONVERT(DATE, [date]+[days])END

SQl job Refer Following Link

http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

Step Tab In Command only paste following text and try,

INSERT INTO LogTable(Id,test)SELECT 1,'TEST'go    DELETE  FROM Estate_V
WHERE CONVERT(DATE, GETDATE()) = CONVERT(DATE, DATEADD(DAY,[days] , [Date])) go
SELECT * FROM LogTable