April 23, 2007 at 8:31 am
Forgive me here, I am not a DBA but work on the operating system side. We have an issue every so often whereby it seems some of our SQL servers have an issue trying to find a DNS server. Therefore some jobs bomb because it cannot send the email. We are using the old Exchange 5.5 client software on our servers for MAPI.
Does anyone have any ideas what might be causing our GRIEF
Let me know either through the post or email me at mgoodyear@newfoundlandpower.com
Thanks
April 25, 2007 at 10:25 am
I think you are confused at what your actual problem is. If you truely beleive you are having a DNS issue, verified using nslookup, then just add the mail server's IP address to the HOSTS file. However if your problem is intermitant network connectivity then that is something your network admin will need to address. If you have no control over the network and can not get your network admins to do anything about, then consider installing SMTP on your DB server. Set up the SQLmail to use an internet mail profile and just have it SMARTHOST emails to your actual mail server. Your email jobs will not bomb because it has successfully handed of femails to the SMTP server on itself and the SMTP server can retry emails until it is successful. This is the current situation I am dealing with.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply