I am using the SQL Server 2000.
On my server there are serveral job waiting to finish. I have found that xp_sendmail task in every package is not finishing and package is in wait condition on that step. Please can any body give help me why xp_sendmail is taking too long
any quick response is most appreciated.
There are several things to look at and a lot more information that would be helpful.
To start with, is sql server set with the correct information for your mail server? And similarly could there be any network problems or network slowdowns between SQL Server and the mail server?
What is the rest of the load on the server? Could it just be generally overwhelmed?
Are you certain that that it is the xp_sendmail call itself that is locking up and not something earlier in the procedure?
Does it give any error messages or warnings at all?
Does it eventually finish if you give it some exhorbitant amount of time, or does it seem to be perpetually locked there?
Does an xp_sendmail command from SSMS complete quickly? What errors do you see?
As Timothy says, we need some mor einfo before we can be a lot more help...
I am getting the error in ERROR LOG, may be it will help you to understand the issue
SqlDumpExceptionHandler: Process 72 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
afterward, the execute xp_sendmail task is halted.
What SP do you currently have installed? If it is not sp3, I would check out the kb article #329375:
http://support.microsoft.com/kb/329375
Also, Article #320407 may apply: Sorry, as a new user, I can only post one link.
