• If its a job please try msdb.sp_send_dbmail