Create a store procedure to delete the data
from table, the rule is, look for date, if it
is before 12 months delete that row.We need to schedule this Sp weekly or
monthly
Please let me know what query should i write for this....
Delte_Data& Shedule SP
Hi,
Deepak VermaPosted Dec 16, 2012, 11:01 PM
You have to create a Job to do it. To know about how to create a Job, follow this link:
http://msdn.microsoft.com/en-in/library/ms187910.aspx