agent not sending notification email when job fails

[aspijker]

Dear DBA's,

On MY sql production server (2000) I am not getting the notification emails when a job failed. I restarted the agent, because usually that would solve this problem, but now it still does not work.

What can I do?

Regards, Salsa

 

[Skittle]

Has it ever worked?

Check your logs.

Check the email account is working by clicking on the 'test' option in SQL Server Agent Properties.



Dazed and confused

 

[aspijker]

I can't test it, because it is a sql 2000 server. I did see the messenger service was disabled, but i doubt that is used for sending notification emails.

I have made a testjob which fails, but then I still don't get an email.

And yes, before it worked.

Regards!

 

[Skittle]

I could be wrong but doen't the MAPI account shown on the page where you right cick agent in SQL 2000 and look at the properties show the account used to send email?

There is a test button on that screen.

I could be that the email account password has expired perhaps?


Dazed and confused

 

[aspijker]

No it works fine on all my servers, accept for this server. I use the same account for all my servers. It must be something on the server.

 

[mrdenny]

What happens in the settings page when you click the test button?

How about when you run xp_test_mapi_profile?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog