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.
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.
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.