Connect

CONNECT_TIME : 19 Jul 2018 08:59:16 GMT

Connected

[SYSTEM@localhost:2506] SDMS> SELECT SE.NAME,SME.START_TS,SME.FINSH_TS,ESD.NAME AS STATUS FROM SCI_SUBMITTED_ENTITY SME,
       SCI_V_SCHEDULING_ENTITY SE,
       SCI_V_EXIT_STATE_DEFINITION ESD
 WHERE SE.ID = SME.SE_ID
   AND SME.SE_VERSION >= SE.VALID_FROM 
   AND SME.SE_VERSION <  SE.VALID_TO
   AND ESD.ID = SME.FINAL_ESD_ID
   AND SME.SE_VERSION >= ESD.VALID_FROM 
   AND SME.SE_VERSION <  ESD.VALID_TO
   AND SME.START_TS >= (SELECT MAX(SSE.START_TS) FROM SCI_SUBMITTED_ENTITY SSE,SCI_V_SCHEDULING_ENTITY SVE WHERE SVE.NAME = 'MOM_BATCH' AND SSE.SE_ID = SVE.ID);

Selected Values

NAME      START_TS                FINSH_TS                NAME   
--------- ----------------------- ----------------------- -------
MOM_BATCH 2018-07-18 22:30:14.388 2018-07-18 22:30:14.388 FAILURE
DUMMY_JOB 2018-07-18 22:30:25.0   2018-07-18 22:30:25.0   FAILURE


2 Row(s) selected

[SYSTEM@localhost:2506] SDMS>