SQL Mail failed sometimes

Last Post 18 Feb 2008 02:39 AM by SQLUSA. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kevincheang
New Member
New Member

--
13 Feb 2008 12:27 AM
Dear all,

I configure SQL2000 to use SQL Mail to send alert thought outlook 2000 clients.

I configured and then running normal. However, it can't send out email sometimes.

e.g. Mon, Tue, Fri work but failed on Wed & Thu. It just showed that can't notify me by email.

I do not changed any setting in this period and our email server (exchange 2000) is working all the

time. Also, sql server is working all the time.

Why? Any log in sql or exchange I can refer? It seems that it is instable in this function.

OS: windows 2000 server sp4 + SQL2000 sp4
windows 2003 server sp2 + SQL2000 sp4

Thanks

Kevin
SQLUSA
New Member
New Member

--
13 Feb 2008 12:39 AM
What so special about WED & THU? Every week?

Did you check event viewer?

Check all histories, logs and queues.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/BI2005WorkShop/ The Best SQL Server 2005 Training in the World!
kevincheang
New Member
New Member

--
13 Feb 2008 06:04 PM
Hi, SQLUSA

I have checked the application logs and found an error as follows:

Event Type: Error

Event Source: SQLSERVERAGENT

Event Category: Job Engine

Event ID: 210

Date: 2/13/2008

Time: 1:00:01 AM

User: N/A

Computer: <computername>

Description:

Unable to send job completion notification email to operator '<username>'

However, I have four jobs will send email to me but just one failed.

In addition, the failed jobs can send me email on Mon but failed on Tue and Wed.

I have no special about Wed and THu. Also no error found in SQL server logs.

Thanks

Kevin
SQLUSA
New Member
New Member

--
13 Feb 2008 10:10 PM
Kevin,

You have to go down the detail level.

I bet any job sending around that time would have failed.....

You may have a malfunction (network trouble....) which may last 5 sec, 5 min, or 5 hours....

Since you have a time to go by, check all other logs, what was down at that time.... including network...


Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/BI2005WorkShop/ The Best SQL Server 2005 Training in the World!
kevincheang
New Member
New Member

--
14 Feb 2008 11:04 PM
Hi, SQLUSA

I have installed a tool which monitor the network connection in this server before.

It seems that no problem in network. I just get the error in the previous post.

Our email server (exchange 2000) also running all the time.

From the error in previous post, it seems that can't notify me by email.

Is is mean that can't connection to email server? Or sql agent error?

Thanks

Kevin
SQLUSA
New Member
New Member

--
15 Feb 2008 02:03 AM
Enter fully qualified names for the distribution list.

Use xp_sendmail for troubleshooting

Article: http://support.microsoft.com/kb/315886


Test with "Include execution trace messages" option (detailed information in SQLAgent log)


You may have some intermittent network or service stoppage.


All SP-s, hotfixes installed?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005grandslam/ The Best SQL Server 2005 Training in the World!
kevincheang
New Member
New Member

--
18 Feb 2008 02:31 AM
I will try your methods for testing. Thanks

I have only sql2000 + sp4 / windows 2003 with sp2,

no other hotfixes. Any hotfix your recommaned to install it?

Kevin
SQLUSA
New Member
New Member

--
18 Feb 2008 02:39 AM
That should be fine.

Let us know when you find the culprit.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/BI2005WorkShop/ The Best SQL Server 2005 Training in the World!
kevincheang
New Member
New Member

--
19 Feb 2008 11:50 PM
Dear SQLUSA,

I used another method to test the network connection between sql server and exchange server.

I use xp_sendmail (sp found from this forum) as the last part of my job. xp_sendmail used to sent email by smtp of my exchange server.

Last night, my job was failed and sql mail failed to send it but xp_sendmail was working.
(ms outlook use exchanged connection and xp_sendmail use smtp)

It seem that network connection and email server are ok (smtp is working now).

The problem are sqlmail to outlook profile failed OR outlook profile can't delivery mail.

How can I found which parts failed? (sqlmail OR outlook profile)

Any suggestion will be welcome.

Kevin
You are not authorized to post a reply.

Acceptable Use Policy