After upgrading our SQL Server from 2008 to 2014, I started noticing this error from a SQL job.The job was failing to send the email with the results.Eventhough the DBMail profile was configured correctly, this generic error was showing up in the logs.
Error
Fix:Enable sysadmin role for the account used to run SQL Server Agent
Now the job runs without any errors and DBmail is able to send the email.
Error
Fix:Enable sysadmin role for the account used to run SQL Server Agent
Now the job runs without any errors and DBmail is able to send the email.
