Post reply

SQLAgentMail

  • March 27, 2007 at 6:58 am

    #69715

    Hi all,

         I’m attempting to create an Exchange Mailbox to support SQLAgent mail. Our exchange administrator claims there’s no reason I shouldn’t be able to us a Lotus Notes

    account. What can I tell him? Thanks to everyone for being there to help.

     

    Ed

     

    SQL 2000 SP4

     

  • March 27, 2007 at 7:02 am

    #697129

    If you can set up Outlook on the server to use Notes I don't think there should be a reason why you could not use Notes. (Never used Notes myself)

  • March 27, 2007 at 10:01 am

    #697204

    Also does anyone know if the SQLMailAgent can be supported by SMTP?

    Thanks,

    Ed

  • March 27, 2007 at 9:13 pm

    #697303

    SQLAgentMail requires a MAPI Client like MS Outlook installed on the server.  We have situations where MS Outlook is not allowed on the SQL server and still must send error messages and messages in generatl from our SQL servers.  There are two options:

    1. link to SP_SQLSMTPMAIL.SQL http://www10.brinkster.com/technologyyogi/SQLFiles/SQLSMTPMail.sql.html

    2. XPSMTP80

    http://www.sqldev.net/xp/xpsmtp.htm

    #1 is performed through a stored procedure that uses CDOSYS to send SMTP mail to a SMTP mail server while.

    #2 is a true extended stored procedure that sends mail to a SMTP mail server.

    I personally have had great experience from either solution.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply