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

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

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:

Download Free e-Books


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.