SQL Server Performance

SMTP mail notifications

Discussion in 'General DBA Questions' started by ananda, Aug 10, 2009.

  1. ananda New Member

    I done following steps for configure via SMTP mail notification
    1. xpsmtp80.dll - download and placed in Bin folder this path C:program FilesMicrosoft SQL ServerMSSQL$BKUPEXECBinn
    2. exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll'
    exce the above command in master databse,
    3. grant execute on xp_smtp_sendmail to public
    4.
    declare @rc int
    exec @rc = master.dbo.xp_smtp_sendmail
    @FROM = N'servername@ril.com',
    @FROM_NAME = N'servername',
    @TO = N'useremail@ril.com',
    @CC = N'',
    @BCC = N'',
    @priority = N'normal',
    @subject = N'Hello SQL Server SMTP Mail',
    @message = N'Goodbye MAPI, goodbye Outlook',
    @type = N'text/plain',
    @attachments= N'',
    @server = N'IPaddress'
    select RC = @rc
    go
    The above script i got test main in my mailbox, it was working fine.
    I have created maintenance plan for db backup, at the end tab i had choose the Emailing report to operator,
    but it was fail, the error messages
    Error 21776: [SQL-DMO]The name 'ananda.murugesan@ril.com' was not found in the Operators collection.
    If the name is a qualified name, use [] to separate various parts of the name, and try again.
    Please tell me, what i should look?
    thanks
  2. ananda New Member

    How to create smtp mail account not in POP3? we are using only smtp. I could tried but it was not hope.. the following error display Emailing report to operator 'sqlmailsend' [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005thanks Here xp_sendmail: i could not get, but smtp using by xp_smtp_sendmail only. Pl can anyone suggestion me, what exact problem? thanks.

Share This Page