What I was hoping was to have an agent job create the report, save the output to excel (which the report suports manually), then dbmail it to me.

Seems I won't...