I've used this for a long time. It's simple and it works. I have since made many tweaks to fit my requirements such as stripping out the CLR.

You can easily make your own changes to add what you want, remove what you don't.

http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx