Problem Description:

Executed as user: abc\xxxxxx. The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229). The step failed.

Problem Resolution:

Step#1: First find out permission for object sp_send_dbmail:

Below query can … Read the rest