October 11, 2010 at 4:00 am
Hi all,
I have a job that runs several jobs it notifies me when the jobs have finished running but for the passed few weeks it has stated to fail with the following message
Executed as user: domainname\username. xp_sendmail: Could not resolve recipient [SQLSTATE 42000] (Error 18031). The step failed.
I have doing some research but I have not no luck. I was wondering if anyone has an answer to this please.
Thank you
October 11, 2010 at 4:20 am
Does it now always fail at this step or is it just sometimes?
We've seen a problem recently with xp_smtp_sendmail being unable to run on SQL Server 2008 64 bit edition. It turns out the DLL is only compatible with 32 bit versions.
Thanks,
Simon
October 11, 2010 at 4:31 am
s_osborne2 (10/11/2010)
Does it now always fail at this step or is it just sometimes?We've seen a problem recently with xp_smtp_sendmail being unable to run on SQL Server 2008 64 bit edition. It turns out the DLL is only compatible with 32 bit versions.
Thanks,
Simon
Yes it just fails when it comes to email but the actual job steps all run fine.
I am using sql 2000, do you have any recommendations for the 2000 sp4 please.
Thank you
October 11, 2010 at 3:37 pm
Just for clarification, are the e-mails actually getting sent out to the intended recipients? It almost sounds like the SMTP server the job is using is rejecting to send the e-mails because it cannot resolve the recipients. It could be that the e-mail server is not setup to relay for your system any longer. Have you checked anything with your mail admins?
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply