Monday, March 19, 2012

Job Failure emails not being sent in SQL 2005

Hi I am trying to configure notification emails on my sql2005 server for SQL
agent job failures. I have configured a mail profile in database mail and I
can send test emails which are received correctly.
I have configured the notification to email me when the job completes but
this is not working and I do not receive any notifications. When I look at
the job history
it gives me the message below after the normal job completion information.
NOTE: Failed to notify 'Email User' via email.
Any ideas as to want i can do to fix this problem.
Cheers
JamesThe most likely cause is that the userid running the job is not permitted to
send email. Check out the authorizations on your mail server and add the
necessary permissions.
"James Matthews" <JamesMatthews@.discussions.microsoft.com> wrote in message
news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
> Hi I am trying to configure notification emails on my sql2005 server for
> SQL
> agent job failures. I have configured a mail profile in database mail and
> I
> can send test emails which are received correctly.
> I have configured the notification to email me when the job completes but
> this is not working and I do not receive any notifications. When I look at
> the job history
> it gives me the message below after the normal job completion information.
> NOTE: Failed to notify 'Email User' via email.
> Any ideas as to want i can do to fix this problem.
> Cheers
> James
>|||On Jan 28, 5:23 am, "Mark Yudkin" <DoNotContac...@.boingboing.org>
wrote:
> The most likely cause is that the userid running thejobis not permitted to
> sendemail. Check out the authorizations on your mailserverand add the
> necessary permissions.
> "James Matthews" <JamesMatth...@.discussions.microsoft.com> wrote in messag
e
> news:30E73785-3D3D-4829-AB4A-3DB82F5E7E4F@.microsoft.com...
>
>
>
>
>
> - Show quoted text -
I encountered the same problem and fixed it by restarting the SQL
SERVER AGENT in Management Studio.

No comments:

Post a Comment