Post reply

Database Mail

  • February 22, 2007 at 1:13 pm

    #116453

    I set up Database Mail, I believe correctly, because when I send a test Email it work. However, I set up a job to send me an email on failure, but when the job fails, there is no email, and the job history notes that it failed to notify the operator. What am I missing?

    Thanks...Nali

  • February 22, 2007 at 10:58 pm

    #691308

    Did you enable mail profile in Mail Session in SQL Agent properties?

    MohammedU
    Microsoft SQL Server MVP

  • February 23, 2007 at 8:43 am

    #691427

    I read that although you set up email in SQL 2005, there is a bug which is supposed to be fixed in SP2.

    So, you will not receive your emil until you install SP2.  We have not installed SP2 yet, so I am not sure if in fact it is fixed or not. 

    Al

  • February 23, 2007 at 9:09 am

    #691444

    This worked after I enabled it in the Agent profiled, and stopped and started the service.

    Thanks...Nali

  • February 23, 2007 at 9:13 am

    #691445

    Are you on SP1 or SP2?

     

  • February 24, 2007 at 12:04 am

    #691606

    I setup the db mail on many servers some of them are RTM and SP1 but not on SP2 without any problems...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply