Morning all!
My SQL server email job notifications have stopped working, but mails sent through the xp_sendmail command still work.
The only thing that has changed recently is the SQL server agent account passwords have been changed, these accounts are normal win2000 domain accounts.
Any ideas cos I am fully stumped?Have you tried testing the SQLMail Profile?
Support Services/SQLMail.
Are SQLMail and SQLAgentMail using the same mail profile?|||Already tested the SQL mail profile and that works ok,
How do I check which profile the sqlagentmail is using?|||Originally posted by SQLSlammer
Already tested the SQL mail profile and that works ok,
How do I check which profile the sqlagentmail is using?
Right click on SQL Agent/Properties and check that it is using the same mail profile.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment