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