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

最新推荐文章于 2022-11-22 18:34:37 发布

BlackHeart1203

最新推荐文章于 2022-11-22 18:34:37 发布

阅读量396

点赞数

本文链接：https://blog.csdn.net/u010304907/article/details/78494859

版权

-- 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';