|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
|
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?
(comments are locked)
|
|
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...
(comments are locked)
|
|
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. Could you provide a code sample of the script you ran that generated this?
Dec 22 '09 at 02:27 PM
TimothyAWiseman
Does the server have all of the relevant service packs?
Dec 24 '09 at 07:41 AM
Fatherjack ♦♦
(comments are locked)
|
