Ask a questionAsk a question
 

AnswerUnable to get Email alerts

  • Friday, October 16, 2009 8:15 PMmkechung Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    I am not sure if I am in the right group.

     

    I am trying to do the following on SQL 2005

    - Email completion alerts from our maintenance jobs.

    - Email task from SSIS tasks.

     

    I have Database Mail running within Management Studio

    I performed a test Email (Database Mail) and I got it.

    I performed a telnet mailserver 25 test and I got it.

    I have a receiver connection with the IP address of the SQL server on my mailserver.

     

     

    I edited a maintenance job and setup an Email alert within the Notifications.

    I run the job and I don't get Email alert (when the job completes)

     

    Any ideas?

     

    Thanks

Answers

  • Saturday, October 17, 2009 3:48 AMmkechung Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Discovered the following.

    Needed to Enable Mail Profile in Database Mail
    Needed to start the Messenger Service

    All is well!

    • Marked As Answer bymkechung Wednesday, October 21, 2009 1:19 AM
    •  

All Replies

  • Saturday, October 17, 2009 3:48 AMmkechung Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Discovered the following.

    Needed to Enable Mail Profile in Database Mail
    Needed to start the Messenger Service

    All is well!

    • Marked As Answer bymkechung Wednesday, October 21, 2009 1:19 AM
    •