Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012

    Unanswered: Send Mail Task Failing in DTS Package

    I have a DTS package in SQL Server 2000 that has a Send Mail task to shoot me an email when it completes. When I tested this manually it ran fine however when it runs as a scheduled job in the SQL Agent the Send Mail task fails. I think a little background would help; prior to being able to send emails I installed Outlook so I could build a MAPI profile. With the MAPI profile there I am able to create and at least manually test a Send Mail task. From experience I believe this issue arises due to the fact that when I'm logged in Outlook is running but when I'm logged out of the Server, it is not running and so the task fails. Any help is appreciated.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    It will be useful for you to share the full failure details that SQL Server Agent reports as this may include an error message hinting to the problem.

    If I had to guess I would say:

    You have set up a MAPI profile for your user account and this works...
    You have not set up a MAPI profile for the user account that SQL Server Agent runs as.
    Home | Blog

Tags for this Thread

Posting Permissions

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