xp_sendmail seems to get stuck

[olemma]

when I execute something like:
EXEC master.dbo.xp_sendmail
@recipients = 'xyz@abc.com',
@subject = 'Daily report',
@message = 'New Customers through midnight yesterday'


it just runs and runs and runs...untill I have to cancel it.

I tried using xp_stopmail and xp_startmail and it still gives me the same problem. I know that this was working before. What could have happened?

 

[olemma]

Anyone?

 

[tlbroadbent]

Which version of SQL server are you running? Which service pack is installed? We had similar problems with SQL 7 mail until we upgraded to SQL 2000. The problem may have been solved in a SQL 7 service pack.

I believe there is a Microsoft knowledgebase article about this problem but I don't have it bookmarked.

I am also aware that stopping and starting mail repeatedly causes a problem. If there are processes that stop and start mail you may want to remove the stop and start code. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.