SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2004
    Location
    Australia
    Posts
    122
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Emailing from SQL Server

    Hi everyone,

    I am running SQL Server Enterprise Manager and i would like to have a query run everynite and send the results returned by the query off to an email address....

    How can i do this?

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,633
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    IIRC, one can do this using the SQL server agent. Look about in the books online and try a google search or three.

    IIRC again, one cannot do much more than send a rather simple message.

  3. #3
    SitePoint Zealot
    Join Date
    Aug 2004
    Location
    Australia
    Posts
    122
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can send the results returned by a query by email which is enough for me

    I got it all setup, got the IMAP setup, xp_startmail, xp_sendmail working. but the gayest thing of all, is none of the emails actually get sent!

    I load up Outlook on the server machine and there is all these emails from the Admin saying "No transport method was available for delivery to this recipient".....


Bookmarks

Posting Permissions

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