Employers - Post Free Jobs
Forum guidelines
AuthorQuestion
Delte_Data& Shedule SP
Posted 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 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

Employers - Post Free Jobs

SPONSORED BY

Offshore Software and Database 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.