I can recall something from training, that you first need to go to msdb and give rights to the SQLagent service account user to some role - role name is 'databasemail' role or something... sorry if this is crap help :D


-----Original Message-----
From: Ivan Gonzalez [mailto:mssqldba-ezmlmshield-x62137256.[Email address protected]
Sent: Friday, June 30, 2006 15:02 PM
To: LazyDBA Discussion
Subject: Database Mail

On my SQL 2005 I have configured Database Mail and I can send email
notifications from Management Studio using an SMPT profile. I created a
test job to test it but am unable to get it to send me notification upon
successful or failure completion.

The SQL Server Agent does not allow me (it ghosts the otpion) to test
the profile. Any ideas??

Thanks,



Ivan







******************NOTICE*******************
This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s) only and may contain privileged, confidential, work-product and/or trade secret information of a proprietary nature. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use, distribution or re-transmission of this e-mail or any attachment(s) is strictly prohibited and that all rights of the sender and/or intended recipients are hereby reserved without prejudice thereto.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page