I had to tweak it a little for it to work for me. I had to add the @profile_name for my sp_send_dbmail to work.

I have the stored procedure saved under master db. I assume this is the best place?

Then the next step is to put this in an SQL agent job to execute on a frequency.

Thanks!