There are many situations that could result in an error sending email.
It would help if you could provide the error code or error description
from the logs. Is this a 500 error? If so, make sure the user security
rights are proper, and make sure the mail server is setup to
forward/relay messages from the server. What stumps me is that the
server works when rebooted, but for how long does it work, and does the
functionality stop after any common cause, or does it just randomly go
down at some point, with no apparent cause at all? Has this gone down
several times, or just once? Is there a resource-intensive backup or
process that occurs around the time the system stops sending emails?
Does the email server have a "dark" or maintenance window? Need
input...

Also, my research turned up this tasty morsel: if you have to restart
SQL Mail, and it's working, then you may want to try the following for a
temporary fix until you solve the root problem: Try running xp_stopmail
and xp_startmail before sending each (batch) of message(s).

Good luck!

Thanks,
Terry

-----Original Message-----
From: Suraparaju Vamsi
[mailto:mssqldba-ezmlmshield-x63842416.[Email address protected]
Sent: Monday, March 31, 2008 10:30 AM
To: LazyDBA Discussion
Subject: xp_sendmail: Failed

Good morning,

My sql jobs failed due xp_sendmail. It was running fine never had an
issue but today when I was checking my sql error log and the job history
I found below one, I know if I re-boot the server it will fix the issue
but it's a production box so I am not comfortable doing so. Is there any
other way to fix this?



It's on Sql 2000, Enterprise Edition,sp2.

xp_sendmail: failed with mail error 0x8004011d [SQLSTATE 42000] (Error
18025). The step failed.



Also I tried sending test mail using:

exec master..xp_sendmail

@recipients = '[Email address protected]

@subject = 'TRO tEST',

@message = 'TRO TESTED'



Got error:

Msg 17925, Level 16, State 1, Line 0

xp_sendmail: failed with mail error 0x80040111





Please give me your thoughts on it,



Thanks

V-





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
This e-mail message and any attachments contain confidential
information from Medco. If you are not the intended recipient, you
are hereby notified that disclosure, printing, copying,
distribution, or the taking of any action in reliance on the
contents of this electronic information is strictly prohibited. If
you have received this e-mail message in error, please immediately
notify the sender by reply message and then delete the electronic
message and any attachments.

MS Sql Server LazyDBA home page