Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    9

    Unanswered: DTS - SQL Server Agent Mail Issue

    Hi,

    Wondering if anyone there can tell me what I'm doing wrong (and please be gentle as I'm not at all techy).

    I have a DTS scheduled on the Server Agent to run, and at the end it is to send a mail to notify me and several others that it has completed. Trouble is, it runs but doesn't send the mail.

    However if I execute the DTS manually it does send the mail.

    I have a idea it might be to do with the Profile in SQL Mail in Server Settings on the Properties of the server, but have no idea how to correct this.
    Can anybody help?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Check out MS KBs:

    311231
    315886
    263556

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Dec 2005
    Posts
    9
    Cheers, will have a look now.

Posting Permissions

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