Environment information: +--------------------+--------------------------------------------------+ |Account Name |KEUTVINTSQL01_MSDB | +--------------------+--------------------------------------------------+ |Database Vendor |Microsoft SQL Server | +--------------------+--------------------------------------------------+ |Database Version |13.00.5264 | +--------------------+--------------------------------------------------+ Request statement: ------------------ execute msdb.dbo.sp_start_job 'GTG_DTC_PutShipmentHistoryToDemantra' +---------------------------------------+ | | | MSSQL Agent Job | | | +-------------------+-------------------+ Job summary: Job: GTG_DTC_PutShipmentHistoryToDemantra Category: [Uncategorized (Local)] Started: 2020-08-09 15:32:29.0 (MSSQL server time) Finished: 2020-08-09 15:32:34.0 (MSSQL server time) Run Duration: 00:04 End Status: Fail Job/Step Details: Status Id Duration Name: Message ------------------------------------------------------------------------------------------------------------------------------ Fail 1) 00:04 Execute GMCR_DTC_GMCR567_004_01_Shipment_Hist_to_Demantra: Executed as user: WTBY\svcIntegSvcIdT. Microsoft (R) SQL Server Execute Package Utility Version 13.0.5264.1 for 32-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 3:32:30 PM Error: 2020-08-09 15:32:34.81 Code: 0x00000063 Source: Throw Control Error Demantra Error Description: Demantra Control Table has wrong Status for T_SRC_SALES_TMPL End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:32:30 PM Finished: 3:32:34 PM Elapsed: 4.203 seconds. The package execution failed. The step failed. Fail 0) 00:04 (Job outcome): The job failed. The Job was invoked by User CtrlM. The last step to run was step 1 (Execute GMCR_DTC_GMCR567_004_01_Shipment_Hist_to_Demantra). Job failure message: CONTROL-M for Databases: DB0001 = The job failed. The Job was invoked by User CtrlM. The last step to run was step 1 (Execute GMCR_DTC_GMCR567_004_01_Shipment_Hist_to_Demantra). Job statistics: +-------------------------+-------------------------+ |Start Time |20200809153229 | +-------------------------+-------------------------+ |End Time |20200809153236 | +-------------------------+-------------------------+ |Elapsed Time |6 | +-------------------------+-------------------------+ |Number Of Affected Rows |0 | +-------------------------+-------------------------+ Exit Code = 1 Exit Message = CONTROL-M for Databases: DB0001 = The job failed. The Job was invoked by User CtrlM. The last step to run was step 1 (Execute GMCR_DTC_GMCR567_004_01_Shipment_Hist_to_Demantra).