Hey Thanks for the reply,

The transaction size is average of 100k/day... this job is scheduled to run everyday... ! 🙂

Will post the sp shortly.. Need to know what are the best methods to do this kind of job.