October 11, 2007 at 4:26 pm
Hi guys, I hope you can help me :crying:
I hace a Sql server, but yesterday it fails with the jobs that has scheduled.
I review the logs in some of them and found the next message:
The job failed. The Job was invoked by Schedule 711 (Comcast RPT340_48). The last step to run was step 1 (Comcast RPT340_48).
This message appears in some messages, but when I saw the details log.
This are some of them:
xecuted as user: HISPANIC\administrator. ... DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSActiveScriptTask_5 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_5 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_3 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217871 (80040E31) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Err... Process Exit Code 1. The step failed.
---------------------------------------------------------------------
Executed as user: HISPANIC\administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
---------------------------------------------------------------------
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147217900 (80040E14) Error string: xp_sendmail: failed with mail error 0x80004005 Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 18025 (4669) Error string: xp_sendmail: failed with mail error 0x80004005 E... Process Exit Code 1. The step failed.
----------------------------------------------------------------------
Executed as user: HISPANIC\administrator. xp_sendmail: failed with mail error 0x80004005 [SQLSTATE 42000] (Error 18025). The step failed.
-----------------------------------------------------------------------
I hope you can tell me what have to change or modify.
Thanks in advance
October 11, 2007 at 4:50 pm
This is a known issue, please read MS article here
http://support.microsoft.com/default.aspx/kb/820220
I would say to use an SMTP server along DBMail if you don't need your sql server to receive mails.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply