SQL Server 2014 DBMail - Failed to initialize sqlcmd library with error number -2147467259.

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.