There should be way why this is happening, is there any one who can
explain me why we have to face this kind of Error at all. Please
-----Original Message-----
From: James Fogel [mailto:[Email address protected]
Sent: Monday, March 31, 2008 3:38 PM
To: Suraparaju, Vamsi
Subject: RE: xp_sendmail: Failed
Mail has always been flaky with SQL Server.
-----Original Message-----
From: Suraparaju Vamsi [mailto:[Email address protected]
Sent: Monday, March 31, 2008 2:36 PM
To: [Email address protected]
Subject: RE: xp_sendmail: Failed
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any
attachments, and kept your email address secret **from this person, and
any
viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text
But why we are getting this kind of error, this has never happened on my
prod box?
-----Original Message-----
From: James Fogel
[Email address protected]
Sent: Monday, March 31, 2008 3:32 PM
To: LazyDBA Discussion
Subject: RE: xp_sendmail: Failed
In my procs that send mail I always stop and start the mail agent to get
around this.
-----Original Message-----
From: Bowman Rita A.
[mailto:mssqldba-ezmlmshield-x72337752.[Email address protected]
Sent: Monday, March 31, 2008 11:23 AM
To: LazyDBA Discussion
Subject: RE: xp_sendmail: Failed
We have this happen occasionally. We stop and start the mail agent using
xp_stopmail and xp_startmail - and it generally goes away. The problem
was
worse before we installed sp3a for SQL 2000. In addition, we use the
following to try to resend 5 times before failing (at sign replaced with
#):
Set #return = 0
Set #Counting = 0
While 1 = 1
Begin
Set #Counting =#Counting + 1
Exec #return = master..xp_sendmail [Email address protected] = 'mail
recipients',
[Email address protected] = 'whatever',
[Email address protected] 'If you have any questions or
concerns,
please email us
at: wecare.com',
[Email address protected]
-- here's the good stuff
If [Email address protected] = 0
--Begin
--Print 'EMAIL Set'
Break
End
Else
Begin
/* Try 5 times */
If [Email address protected] = 5
Break
Print 'Email Failed - Wait 10 seconds, try again'
/* 000 hours, 00 minutes, and 10 seconds */ WaitFor delay '000:00:10'
End
end
End
-----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
[Email address protected] = '[Email address protected]
[Email address protected] = 'TRO tEST',
[Email address protected] = '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
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
MS Sql Server LazyDBA home page