Adding the account that sql server agent runs under to the databaseMailUserRole in msdb and the db_datareader role of the db (or dbs) where sp_send_dbmail is pulling data has always...
You shouldn't have to put the account that runs sql agent into the sysadmin role. It just needs to be a member of the DatabaseMailUserRole in msdb and a...