일회성 스케줄 등록정보 조회시

SELECT  T.*
FROM   (SELECT  SUBSTR(T.TRIGGER_NAME, -36)                                                                                     AS APP_ID
      --,       T.TRIGGER_NAME
        ,       T.TRIGGER_GROUP
        ,       T.JOB_NAME
      --,       T.JOB_GROUP
      --,       T.NEXT_FIRE_TIME
        ,       TO_CHAR(TO_DATE('1970-01-01') + T.NEXT_FIRE_TIME / (1000 * 60 * 60 *24), 'YYYY-MM-DD HH24:MI:SS')               AS SCH_DT
        ,       TO_CHAR(TO_DATE('1970-01-01') + T.NEXT_FIRE_TIME / (1000 * 60 * 60 *24) + (9 / 24), 'YYYY-MM-DD HH24:MI:SS')    AS SCH_DT9  -- +09:00
        ,       T.TRIGGER_STATE
      --,       T.TRIGGER_TYPE
      --,       T.START_TIME
        FROM QRTZ_TRIGGERS T
        WHERE T.TRIGGER_TYPE = 'SIMPLE') T
;





APP_ID                              |TRIGGER_GROUP|JOB_NAME        |SCH_DT             |SCH_DT9            |TRIGGER_STATE|
------------------------------------+-------------+----------------+-------------------+-------------------+-------------+
b2262eeb-f682-4726-8552-447f8b59165a|RFX          |RFX_CLOSE       |2023-01-25 09:00:00|2023-01-25 18:00:00|WAITING      |
6731b450-6ac5-42c6-abcc-d08f78082c87|NEGO         |CLOSE_NEGO      |2023-01-23 16:01:00|2023-01-24 01:01:00|WAITING      |
6fcf8d86-f5ec-498b-93f7-d6ecb13565f1|RFX          |RFX_CLOSE       |2023-01-23 09:00:00|2023-01-23 18:00:00|WAITING      |
aa4fd134-7f3d-407f-af7a-c35273617020|RFX          |RFX_CLOSE       |2023-01-22 09:00:00|2023-01-22 18:00:00|WAITING      |
84f491c2-e4bd-4317-bb1c-b0356e84cebc|RFX          |RFX_CLOSE       |2023-01-23 09:00:00|2023-01-23 18:00:00|WAITING      |
15730f4e-86e5-48aa-a59e-2f025d027ff7|EVAL         |closeCmpl       |2023-01-22 15:00:00|2023-01-23 00:00:00|WAITING      |
8cc3ce21-21ca-4815-8dd2-759d1f176346|RFI          |RFI_CLOSE       |2023-01-23 05:30:00|2023-01-23 14:30:00|WAITING      |
082a8877-58f5-486e-91bd-fcfb637e759a|RFX          |RFX_CLOSE       |2023-01-24 09:00:00|2023-01-24 18:00:00|WAITING      |
ca8e98bf-cb42-49b9-aeb4-b7cd850da72f|NEGO         |CLOSE_NEGO      |2023-01-25 16:01:00|2023-01-26 01:01:00|WAITING      |
f9a98b35-7946-4065-919c-73b1801207c3|BN           |BN_CLOSE        |2023-01-25 09:00:00|2023-01-25 18:00:00|WAITING      |
809d810f-1b89-4552-946c-01072caaa708|RFX          |RFX_CLOSE       |2023-01-25 09:00:00|2023-01-25 18:00:00|WAITING      |
082a8877-58f5-486e-91bd-fcfb637e759a|RFX_PRE_INSP |RFX_PRE_INSP_END|2023-01-24 09:00:00|2023-01-24 18:00:00|WAITING      |