locked
why SqlServer job getting succeed Even though error in the Jobstep? RRS feed

  • Question

  • Hi All,

    I have Create a job as ETL_Load which calls SSIS Package. Outcome of this Package is error. The same error return to Job steps from SSIS package. But Eventhougth the Job step is having an error, job getting succeed.

    In Job step Advanced tab, on success action and on failure action set correctly. The below are the JobStep history. Can you please suggest me what could be the problem here

    Executed as user: ENTERPRISE\kumaba02. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.2500.0 for 32-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  6:05:16 AM  Error: 2012-04-02 09:39:29.26     Code: 0xC002F210     Source: Usp_OR_SQL_Xcd_Dscr_v Execute SQL Task     Description: Executing the query "Exec Ogrds_ETL.Usp_OR_SQL_Xcd_Dscr_v  " failed with the following error: "Could not find stored procedure 'Ogrds_ETL.Usp_OR_SQL_Xcd_Dscr_v'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_SUCCESS (0).  Started:  6:05:16 AM  Finished: 9:39:29 AM  Elapsed:  12853.3 seconds.  The package executed successfully.  The step succeeded.
    The job succeeded.  The Job was invoked by User ENTERPRISE\kumaba02.  The last step to run was step 1 (FinalPkg_New).

    Thanks in Advance!


    Thanks & Regards, Anil

    Tuesday, April 3, 2012 1:48 PM

Answers

  • You would need to post up your SSIS package for us to determine why it returns success.  Do you have Fail Package on Failuer = true for the step that is executing the stored procedure?

    Insight: The ability to see a thrilling adventure where others see only a near-death experience

    • Proposed as answer by Eileen Zhao Thursday, April 5, 2012 7:11 AM
    • Marked as answer by Eileen Zhao Thursday, April 12, 2012 7:52 AM
    Tuesday, April 3, 2012 2:44 PM