SQL Job data purging and archivng

Posted by Anonymus under Sql Server on 10/10/2012 | Points: 10 | Views : 1031 | Status : [Member] | Replies : 0
I am having a stored proc that does data archiving and purging and there after sends email notfication giving status as to the job is complete or failed. We have set a sql job that run a specific day.

However, in the email notification I also need to add the date range for which the data is archived and purge and no. of of rows affected.
I need help on this . Can any one let me know how can I include this?



(No response found.)

Login to post response