Automatically Delete Record from table

Question

i want that record automatically delete from table after 24 hours in c# (using linq to sql)

Jignesh Trivedi · Answer

Hi To achieve this you have to create console application which is run one time per day that delete your old record from table. else you can use SQL JOB to perform the same operation. A job is a specified series of operations performed sequentially by SQL Server Agent. A job can perform a wide range of activities including running Transact-SQL scripts command prompt applications Microsoft ActiveX scripts Integration Services packages Analysis Services commands and queries or Replication tasks. Jobs can run repetitive or schedulable tasks and they can automatically notify users of job status by generating alerts thereby greatly simplifying SQL Server administration. Please refer for SQL job... http://msdn.microsoft.com/en-us/library/ms186273.aspx hope this will help you.