我有以下脚本:
SELECT
username
ITEM
BUSInesS
ADDED
FROM BUSInesS
WHERE
BUSInesS IN ('X','Y','Z')
AND ADDED BETWEEN TO_DATE('8/30/2019 00:00:00','MM/DD/YYYY HH24:MI:SS') AND TO_DATE('9/30/2019 11:59:59','MM/DD/YYYY HH24:MI:SS')
日期间隔是正确的,但我希望每个预定作业后更改日期。预定的作业脚本如下:
SYS.DMBS_SCHEDULER.CREATE_JOB
(
job_name => 'test',start_date => TO_TIMESTAMP_TZ('2019/10/23 09:00:00.000000 US/Eastern','yyyy/mm/dd hh24:mi:ss.ff tzr'),repeat_interval => 'FREQ=MONTHLY' INTERVAL=1',end_date => NULL
等等
我相信我只需要更改脚本中的日期格式,但是如何确保脚本日期在每次计划的作业运行后提前1个月?预先感谢。