Home Forums SQL Server 2005 Business Intelligence What does DTSER_CANCELED mean? RE: What does DTSER_CANCELED mean?

  • September 3, 2014 at 5:02 am

    #1742726

    dndaughtery (9/2/2014)

    I have a package running from a job and its been running fine for quite some time. It failed recently with the following error but ran fine on the next scheduled attempts. What does the following error message mean?

    Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:00:01 AM DTExec: The package execution returned DTSER_CANCELED (3). Started: 6:00:01 AM Finished: 5:01:38 PM Elapsed: 39696.1 seconds. Process Exit Code 3. The step failed.

    My guess is that after 11 hours, someone canceled the job.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP