HDM接口执行定时刷新查询脚本

– SELECT * FROM QRTZ_TRIGGERS;
SELECT t.next_fire_time,t.trigger_state FROM QRTZ_TRIGGERS t;
– 1501056555000
– 1501056540000
SELECT TO_CHAR(1501123080000 / (1000 * 60 * 60 * 24) +
TO_DATE(‘1970-01-01 08:00:00’这里写代码片, ‘YYYY-MM-DD HH:MI:SS’), ‘YYYY-MM-DD HH:MI:SS’) AS CDATE
FROM DUAL;
– 1501056690000
– 1501056705000
–select sysdate from dual;

select * from hbi_dcm_odi11_scene_exec t where 1=1 and t.exec_status=’R’;
select * from HBI_DCM_IMPORT_LOG t where t.status=’RUNNING’;