I'm setting up a Maintenance Plan in SQL 2005. It is a simple plan to just backup sql databases. After the JOB is done, I want it to email me with a report of the summary whether it's failed or succeeded.
How do I go about doing that?
I was able to setup an SQL Operator, and use the NOtifiy Operator Task at the end but that just seems to be a way to email a person with a generic text that I define and not the actual summary report