locked
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

     

    Properties

     

    Alert system

     

    Enable mail profile

     

    Friday, June 20, 2008 12:26 PM