locked
problem notification e-mail when job failure RRS feed

  • Question

  • HI all,
    I build a simple job that failure....like SELECT * FROOOM table and in the notification introduce an operator (me).
    Now I got enable database mail, try with e-mail test from MANAGMENT > DATABSEMAIL > SEN e-MAIL TEST.

    This one arrive me successful, but on JOB failure never coming...

    This is a problem 'cause I don't see the failure of importante tasks like back-up.

    Some one can give me a feedback how I can correctly set-up database mail. I got 5 sqlserver instance and only one don't send me message.

    Alen Italy
    Tuesday, July 15, 2008 8:49 AM

Answers

All replies

  • * Moved to Getting Started...

     

    A few basic checks:

     

    Can you confirm that you have the job set up with a Notification to send an email on failure? Does the operator you are alerting to have a valid email address?

     

     

     

    Tuesday, July 15, 2008 12:29 PM
  • Absolutly yes
    Tuesday, July 15, 2008 1:38 PM
  • Do you have any messages in the Database Mail Log?

     

    Tuesday, July 15, 2008 2:34 PM
  • no, only start and a end process

    Message
    DatabaseMail process is started


    Message
    DatabaseMail process is shutting down

    Tuesday, July 15, 2008 3:00 PM
  • did enable mail profile on SQL Agent and restart the SQL agent service ?

    SQLCHANTer

    Thursday, August 8, 2013 1:24 AM