August 10, 2016 at 4:11 am
Hi Experts,
I tried to create a job which will send data from a table and send it as mail. It was throwing error initially and when i changed the service account of agent to local system it worked. But then again i tried to run the agent job in 'Run As ' by creating a SQL login but its failing with error Execute permission was denied on sp_send_dbmail . I have given all permission and the user can run the TSQL in SSMS without any issue.
What permission I am missing here?
August 10, 2016 at 2:42 pm
The user needs access to at least one mail profile and needs to be a member of DatabaseMailUserRole in msdb.
Sue
August 15, 2016 at 12:29 am
Sue_H (8/10/2016)
The user needs access to at least one mail profile and needs to be a member of DatabaseMailUserRole in msdb.Sue
Thanks Sue,
As i mentioned earlier i haven given all the permission but the job was failing. I changed the job owner to the user to which the permissions are given other than Run As and it worked fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply