xp_sendmail executes forever

bsrini · April 16th, 2004, 02:55 AM

Hi,

I have configured SQL Mail with the following settings.

Env:

Windows NT 4.0
SQL Server 7.0 SP4

- SQL Service and SQLAgent running on domain account, SQL Mail has been tested with this account and it is successful.
- We are able to send mail from the operators in the SQL Agent, but when we try to send using xp_sendmail it says "Executing query batch", this continues forever. No response.

The same setup in other servers are working fine.

What could be the reason ?

tracymatthews · March 14th, 2006, 06:51 PM

Did you ever resolve this? I'm having the exact same problem.

Thanks,
Tracy

Quote:

quote:Originally posted by bsrini
Hi,

I have configured SQL Mail with the following settings.

Env:

Windows NT 4.0
SQL Server 7.0 SP4

- SQL Service and SQLAgent running on domain account, SQL Mail has been tested with this account and it is successful.
- We are able to send mail from the operators in the SQL Agent, but when we try to send using xp_sendmail it says "Executing query batch", this continues forever. No response.

The same setup in other servers are working fine.

What could be the reason ?

tracymatthews · March 14th, 2006, 06:56 PM

Did you ever resolve this? I'm having the exact same problem.

Thanks,
Tracy

Quote:

quote:Originally posted by bsrini
Hi,

I have configured SQL Mail with the following settings.

Env:

Windows NT 4.0
SQL Server 7.0 SP4

- SQL Service and SQLAgent running on domain account, SQL Mail has been tested with this account and it is successful.
- We are able to send mail from the operators in the SQL Agent, but when we try to send using xp_sendmail it says "Executing query batch", this continues forever. No response.

The same setup in other servers are working fine.

What could be the reason ?