Notification if jobfailure via DBMail on SQL2005 RRS feed

  • Question

  • Hi all

    I set up sql 2005 and defined some daily Backup Jobs. Now I configured the DBMail and tested it directly.

    It works fine, I received the email via SMTP in behalf of the SQL DBMail.


    If I go to my BackupJobs, under

    - SQL Server Agent

       - Jobs

         - MyBAckup Job


    Do a right click and go to Notifications: There you can just activate the notification via email if the job fails, succceed or complets.

    The problem is I can not choose any email account that it should adress, eventhough I can activate it.


    Anyone has an idea why.


    Thursday, June 12, 2008 1:45 PM

All replies

  • You have to configure SQL Server Agent for database mail.


    Right click on SQL Server Agent




    Alert system


    Enable mail profile


    Friday, June 20, 2008 12:26 PM