• 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