MS SQL 2000 server - SQL Mail Job Failed!
One fine day, one of my jobs which sends e-mail notification failed.
when tried to check the xp_sendmail it was failing with the error "failed with mail error 0x80040119"
Solution:
I did the following to stop and start the Mail session, from then it started working fine.
EXEC master..xp_stopmail -- Stop Mail Session
EXEC master..xp_startmail -- Start Mail Session
Subscribe to:
Posts (Atom)