September 3, 2012 at 3:55 am
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
September 3, 2012 at 4:47 am
manju.ccc (9/3/2012)
1.Database mail is enabled2.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
September 3, 2012 at 8:24 am
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