Syed Jahanzaib Bin hassan (6/30/2011)

---

create procedure DeleteOlddata_SP

as

Begin

Delete top(10000)

from SC_SampledNumericDataFact_Table

where DatetimeAdded<getdate()-180

End

And schedule this Store Procedure on the SQL Server Agent job with minimum interval of 15 mins,when you perform...