Forum guidelines
AuthorQuestion
Delte_Data& Shedule SP
Posted By shakib qureshi on 13 Dec 2012
Hi,

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....




AuthorReply
Re: Delte_Data& Shedule SP
Posted By Deepak Verma on 16 Dec 2012  
Hi Shakib,

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

SPONSORED BY

Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.