Right-click the SQL Agent, choose Properties/Advanced and enable a
Database Mail profile for the Agent to use. :)

-----Original Message-----
From: Richard Baumet
[mailto:mssqldba-ezmlmshield-x66203471.[Email address protected]
Sent: Friday, June 30, 2006 8:51 AM
To: LazyDBA Discussion
Subject: RE: Database Mail

Did you put in SP1 yet?

-----Original Message-----
From: Ivan Gonzalez
[mailto:mssqldba-ezmlmshield-x62137256.[Email address protected]
Sent: Friday, June 30, 2006 6:02 AM
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
The information contained in this electronic message is for the
exclusive and confidential use of the addressee. Any other distribution,
use, reproduction or alteration of the information contained in this
electronic message, by the addressee or by any other recipient, without
the prior written consent of the sender is strictly prohibited. If you
have received this electronic message in error, please notify the
sender.



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




---------------------------------------------------------------------------------------------------
NOTICE OF CONFIDENTIALITY
The information contained in this communication and any accompanying document(s) is proprietary and confidential and is intended solely for the above-named individual or entity. If you are not the intended receiver, recipient or entity, you are advised that any distribution, copying, disclosure or communication of this email is strictly prohibited. If you have received this email in error, please contact me at the telephone number listed above or 858.716.1500.
==============================================================================


MS Sql Server LazyDBA home page