Results 1 to 4 of 4

Thread: Auto e-mails

  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Unanswered: Auto e-mails

    Hello,

    I have a SQL server though a hosting company and I am trying to send autoemails using xp_sendmail. The permissions were set and I used the following command to test it.

    EXEC master.dbo.xp_sendmail
    @recipients='tracey@yahoo.com',@subject='test',@me ssage='testing
    sql stored procedure'

    It gave me a message saying "Mail sent" but there none in my e-mail box.

    How do I set yp the SQL Mail server, right? Please help. I don't know what is happening.

    Thanks,
    Tracey

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Auto e-mails

    Have you checked whether the Mail Service has been turned on and the machine has MS Outlook installed(And it has to work)?

  3. #3
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    And an Outlook need to have mail configured using the same account the SQL Server Agent runs as.
    -bpd

  4. #4
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Insead of all that, you could use CDO to send mail, which eliminates the need to have Outlook installed.

    Check out this:
    http://msdn.microsoft.com/library/de...ts_library.asp

    and this:
    http://msdn.microsoft.com/library/de...s_library_.asp
    -bpd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •