Post reply

Jobs not running

  • 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 

  • May 12, 2004 at 7:45 am

    #506145

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

  • June 18, 2004 at 3:49 am

    #510976

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

  • June 18, 2004 at 7:08 am

    #511014

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

  • June 18, 2004 at 7:16 am

    #511018

    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

  • June 18, 2004 at 8:36 am

    #511050

    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.

  • January 5, 2006 at 2:41 am

    #612813

    Hello,

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

    Mathias

  • January 25, 2006 at 2:53 pm

    #617048

    Hello

     

    I Can nod resolve these problem

     

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

    Thanks a lot

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

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