I am running SQL Server 2005 and trying to set up another profile for dbmail.
I have set up the profile, and the account, set all the properties and saved
it. When I right click Database Mail and click Send Test E-mail, the new
profile appears in the Database Email Profile dropdown (called IRMail).
However, when I try to use sp_send_dbmail with the profile_Name = 'IRMail' I
get the following error:

Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42
profile name is not valid

So I query the sysmail_profile table and can only see one profile, however I
can send test email's from the IRMail profile. Did I miss a step?

Thanks.

John