pl/sql 使用Quartz 定时任务 修改下一次定时任务时间

----查看定时任务下一次执行时间
SELECT  sched_name,trigger_name,
    prev_fire_time/24/60/60/1000+TO_DATE('1970-01-01', 'yyyy-mm-dd')+numtodsinterval(8, 'hour') AS prev_fire_time,
    next_fire_time/24/60/60/1000+TO_DATE('1970-01-01', 'yyyy-mm-dd')+numtodsinterval(8, 'hour') AS next_fire_time 
FROM EST_TRIGGERS WHERE trigger_name IN ( 'fncT1ReportStep1JobTrigger','fncT1ReportStep2JobTrigger');

----修改下一次定时任务时间
update EST_TRIGGERS t
set t.next_fire_time =
     (SYSDATE +numtodsinterval(45, 'second') -
     numtodsinterval(8, 'hour') - to_date('1970-01-01', 'yyyy-mm-dd')) * 24 * 60 * 60 * 1000
where 1=1
  AND t.trigger_name in ('fncT1ReportStep1JobTrigger');

--时间函数互换：
select sysdate as 当前时间,
     sysdate +numtodsinterval(45, 'second') as 加45秒,
     sysdate + numtodsinterval(50, 'minute') as  加50分钟,
     sysdate + numtodsinterval(1, 'hour') as 加1小时,
     sysdate + 3 as  加3天,
     add_months(sysdate, 4) as  加4个月,
     add_months(sysdate, 12 * 2) as  加2年
  from dual;