I think the only thing you're missing is the URL to Books Online for the procedure you're going to use to send the email. It's https://msdn.microsoft.com/en-us/library/ms190307(v=sql.110).aspx. It includes information on how to run a query and attach it.

I've also used it for years and have found it to be very reliable. If I were doing this, I would write a procedure to do the work you need done. One part of it would send the email using the sp_send_dbmail stored procedure. Then, simply create a database job to execute the procedure.