Hi I am intending to update status table once DI job gets completed. Once job executes successfully status_code updates properly to 1 but once encountered an error it's not updating at all. We tried proc sql but it was not working so tried data step to update. MPRINT(JOB_IS_ERRR_EXIST): DATA TRANSACTION; MPRINT(JOB_IS_ERRR_EXIST): FORMAT JOB_RUN_SKEY 20. JOB_END_TIME DATETIME20.; MPRINT(JOB_IS_ERRR_EXIST): JOB_STATUS_CDE = -1; SYMBOLGEN: Macro variable JOB_RUN_SKEY resolves to 1857990024574 MPRINT(JOB_IS_ERRR_EXIST): JOB_RUN_SKEY =1857990024574; MPRINT(JOB_IS_ERRR_EXIST): JOB_END_TIME=DATETIME(); MPRINT(JOB_IS_ERRR_EXIST): RUN; NOTE: Compression was disabled for data set WORK.TRANSACTION because compression overhead would increase the size of the data set. NOTE: The data set WORK.TRANSACTION has 1 observations and 3 variables. PROCEDURE| _DISARM| STOP| _DISARM| 2018-11-16T12:21:14,175+05:1800| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 25952256| _DISARM| 17993728| _DISARM| 14| _DISARM| 15| _DISARM| 136| _DISARM| 21478| _DISARM| 0.000000| _DISARM| 0.002801| _DISARM| 1857970274.173060| _DISARM| 1857970274.175861| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(JOB_IS_ERRR_EXIST): data ODSDMSAS.DSI_PROD_CTRL_TBL; MPRINT(JOB_IS_ERRR_EXIST): modify ODSDMSAS.DSI_PROD_CTRL_TBL TRANSACTION ; MPRINT(JOB_IS_ERRR_EXIST): by JOB_RUN_SKEY; MPRINT(JOB_IS_ERRR_EXIST): RUN; 36 The SAS System 12:20 Friday, November 16, 2018 NOTE: The data set ODSDMSAS.DSI_PROD_CTRL_TBL has been updated. There were 0 observations rewritten, 0 observations added and 0 observations deleted. NOTE: There were 0 observations read from the data set WORK.TRANSACTION. PROCEDURE| _DISARM| STOP| _DISARM| 2018-11-16T12:21:14,510+05:1800| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | _DISARM| 25952256| _DISARM| 17993728| _DISARM| 14| _DISARM| 15| _DISARM| 0| _DISARM| 21478| _DISARM| 0.020000| _DISARM| 0.333983| _DISARM| 1857970274.176700| _DISARM| 1857970274.510683| _DISARM| 0.010000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 0.33 seconds cpu time 0.02 seconds JOB_RUN_SKEY JOB_ID JOB_NAME JOB_SAS_CDE TGT_TBL_NME TGT_TBL_DESC JOB_ETL_NME JOB_START_TIME JOB_END_TIME JOB_STATUS_CDE 1857990024574 574 ABR_PREPAID_CARDS_JOB ABR_PREPAID_CARDS_JOB 16Nov2018 12:20:24 0 Status Code 0 meaning job has been executed. Once job got an error status code didn't change. Please help
... View more