Lowell:
Thanks again for your detailed response to my questions.
#1:
I executed the following script but it did not drop db_owner from DatabaseMailUserRole.
Do I need to stop and start SQL Server for this action to take place?
USE msdb;
sp_droprolemember 'db_owner','DatabaseMailUserRole'
#2:
I executed the following script (in my test I substituted ClarkKent with a real user name):
USE msdb;
--add our user
CREATE USER ClarkKent FOR LOGIN ClarkKent;
--give this user rights to use dbmail
exec sp_addrolemember 'DatabaseMailUserRole', 'ClarkKent'
In my stored procedure I added with execute as 'ClarkKent'
I made the profile public and default profile.
The script still fails when run as a job.
Can you tell me if I have missed a step or two?
Thanks
Howard