Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

agent not sending notification email when job fails

Status
Not open for further replies.

aspijker

Programmer
Feb 14, 2007
37
NL
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
 
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
 
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!
 
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
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top