Jobs not running

Question

Post reply

Jobs not running

fred2002

SSCrazy

Points: 2943
More actions
May 11, 2004 at 3:34 am

#108243

I have many Jobs planned during the night. And something is very strange since a few weeks. The jobs failed sometimes and i need to stop and restart the sqlServer Agent service then the planified jobs are running. The error message i got look like:
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B) Error string: The task reported failure on execution. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task reported failure on execution. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

Could somebody help?
Fred

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 1

Do you have the package set to output to an error file? If so, what does it say?

fred2002 SSCrazy Points: 2943 More actions · Answer 2

got still the same error. The error output file doesnt give good informations

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 3

What does it say? Telling me the information is no good doesn't help. You may be right, but let's see it first.

fred2002 SSCrazy Points: 2943 More actions · Answer 4

here is the message from the error log:

he execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Descriptionackage failed because Step 'DTSStep_DTSActiveScriptTask_2' failed.

Error code: 80040428

\Error Help File:sqldts80.hlp

Error Help Context ID:700

Package Name: OPETAX - FTP PLE2

Package Description: (null)

Package ID: {C5488F73-1C9B-11D7-9464-00C04F170B7C}

Package Version: {ACD760C9-C94B-4880-B660-1D9F25254E73}

Package Execution Lineage: {9F819FA4-3AD3-47D0-B936-D91EF480EB0F}

Executed On: SQLPROD01

Executed By: sqlserver

Execution Started: 6/17/2004 9:15:00 PM

Execution Completed: 6/17/2004 9:15:01 PM

Total Execution Time: 0.25 seconds

Package Steps execution information:

Step 'DTSStep_DTSFTPTask_1' was not executed

Step 'DTSStep_DTSActiveScriptTask_1' was not executed

Step 'DTSStep_DTSExecutePackageTask_1' was not executed

Step 'DTSStep_DTSCreateProcessTask_1' was not executed

Step 'DTSStep_DTSActiveScriptTask_2' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:The task reported failure on execution.

Step Error code: 8004043B

Step Error Help File:sqldts80.hlp

Step Error Help Context ID:1100

Step Execution Started: 6/17/2004 9:15:00 PM

Step Execution Completed: 6/17/2004 9:15:01 PM

Total Step Execution Time: 0.235 seconds

Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed

RonKyle SSC-Dedicated Points: 31557 More actions · Answer 5

This is actually helpful. The next thing I'd like you to do is to right click on each step to run it individually. Once you get to the step that is called ActiveXScriptTask_2, you should get a clearer email message. Tell me the error you get when you do that.

Mathias Schlichter Grasshopper Points: 17 More actions · Answer 6

Hello,

I do have the same Problem! Could you solve it in the meantime?

Mathias

Alejandro Javier Grinkraut Grasshopper Points: 19 More actions · Answer 7

Hello

I Can nod resolve these problem

any could say me the solution !!! ???

Thanks a lot