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?