Failed to Notify Operator via Email

  • 1.Database mail is enabled

    2.SQL Server Agent's alert system is configured

    3.Database mail is enabled, and "send test email" succeeds (to the same email I want to send to).

    4.When the job completes, I don't see any new entries in msdb.sysmail_allitems

    Looking at the job history, entries show:

    The job succeeded. The Job was invoked by User DBA. The last step to run was step 1 (test). NOTE: Failed to notify 'Operator' via email.

    Pls Help Me:-D

  • manju.ccc (9/3/2012)


    1.Database mail is enabled

    2.SQL Server Agent's alert system is configured

    3.Database mail is enabled, and "send test email" succeeds (to the same email I want to send to).

    4.When the job completes, I don't see any new entries in msdb.sysmail_allitems

    Looking at the job history, entries show:

    The job succeeded. The Job was invoked by User DBA. The last step to run was step 1 (test). NOTE: Failed to notify 'Operator' via email.

    Pls Help Me:-D

    1. Make sure you have restarted the SQL Server Agent after configuring the Alert system to "Database Mail".

    2. Make sure you have created the operator with correct email address.

    3. Make sure you have selected correct operator in the job configuration


    Sujeet Singh

  • Thanks Divine Flame,

    I did everything.

    Restart the Agent and test the operator using SP_NOTIFY_OPERATOR it returns the test mail thats means email acc is ok. that is the only operator.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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