sql job failed

Hi all,

I got an error when running an sql job agent,

The package execution failed in execute task editor. as its showing red icon.

the error msg was:

Message
Executed as user: ABC. ...sion 12.0.2000.8 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  07:04:19  Progress: 2015-08-26 07:04:20.29   
Source: Incremental Update - Transfer Stage to Final tables      Validating: 0% complete  End Progress  Progress: 2015-08-26 07:04:20.33    
Source: Incremental Update - Transfer Stage to Final tables      Validating: 6% complete  End Progress  Progress: 2015-08-26 07:04:20.34     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 12% complete  End Progress  Progress: 2015-08-26 07:04:20.36     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 18% complete  End Progress  Progress: 2015-08-26 07:04:20.37     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 25% complete  End Progress  Progress: 2015-08-26 07:04:20.38     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 31% complete  End Progress  Progress: 2015-08-26 07:04:20.39     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 37% complete  End Progress  Progress: 2015-08-26 07:04:20.41     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 43% complete  End Progress  Progress: 2015-08-26 07:04:20.42     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 50% complete  End Progress  Progress: 2015-08-26 07:04:20.42     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 56% complete  End Progress  Progress: 2015-08-26 07:04:20.42     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 62% complete  End Progress  Progress: 2015-08-26 07:04:20.43     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 68% complete  End Progress  Progress: 2015-08-26 07:04:20.43     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 75% complete  End Progress  Progress: 2015-08-26 07:04:20.44     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 81% complete  End Progress  Progress: 2015-08-26 07:04:20.44     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 87% complete  End Progress  Progress: 2015-08-26 07:04:20.44     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 93% complete  End Progress  Progress: 2015-08-26 07:04:20.45     
Source: Incremental Update - Transfer Stage to Final tables      Validating: 100% complete  End Progress  Progress: 2015-08-26 07:04:20.53     
Source: Create Enums Enumeration     Dropping table wdItemResourceType: 0% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Creating table wdItemResourceType: 0% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Creating index on table wdItemResourceType: 0% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 0% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 20% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 40% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 60% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 80% complete  End Progress  Progress: 2015-08-26 07:04:20.54     
Source: Create Enums Enumeration     Inserting into table wdItemResourceType: 100% complete  End Progress  Progress: 2015-08-26 07:04:20.55     
Source: Create Enums Enumeration     Done: 100% complete  End Progress  Progr...  The package execution fa...  The step failed.

may i know the reason for it??

as i am new to this field can you guide me through it.

Thanks 

August 26th, 2015 3:16am

Hi,

What you could try is:

1. Open the Job
2. Click Edit on the step that you want to capture the error.
3. Go to Advanced tab
4. Specify the Output file. This will be file where all your errors related to that step will be written.

You can also define logging to a database in the package itself

Hope this helps.

Caroline

Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 3:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics