什么是"INTERVAL = 0"?在Oracle Schedular中意味着什么? [英] What is "INTERVAL=0" means in Oracle Schedular?

问题描述

我的Oracle DBA设置了一个具有以下repeat_interval的任务:

My Oracle DBA have setup a task with following repeat_interval:

Start Date :"30/JAN/20 08:00AM"
Repeat_interval: "FREQ=DAILY; INTERVAL=0; BYMINUTE=15"

我可以问一下"Interval=0"是什么意思吗? 这是否意味着此任务将每天从上午8点开始运行，并且每15分钟重复一次，直到成功?

Can I ask what is "Interval=0" means? Does it means this task will run daily from 8AM, and will repeat every 15 mins until success?

我试图从Google那里获得答案，但是我发现的是Interval = 1，但0无效.

I tried to get the answer from Google, but what I find is what is Interval=1, but nothing for 0.

如果有人可以在这里与我分享一些信息，那就太好了.

So would be great if anyone can share me some light here.

提前谢谢！

推荐答案

INTERVAL是两次执行之间FREQ值的增量数.我相信在这种情况下0或1的值将是相同的.所示计划将在随机小时后大约15分钟(BYMINUTE = 15，但未设置BYHOUR和BYSECOND)的情况下，每天执行一次(FREQ = DAILY).

INTERVAL is the number of increments of the FREQ value between executions. I believe in this case that a value of 0 or 1 would be the same. The schedule as shown would execute once per day (FREQ=DAILY), at approximately 15 minutes past a random hour (BYMINUTE=15, but BYHOUR and BYSECOND are not set).

计划与上一次执行是否成功无关. 开始日期"仅是启用作业的日期，而不是实际开始处理的日期.

Schedule has nothing to do with whether or not the previous execution succeeded or not. Start Date is only the date at which the job was enabled, not when it actually starts processing.

如果您希望它从启用之时起每15分钟运行一次，则应进行以下设置:

If you want it to run every 15 minutes from the moment you enable it, you should set as follows:

FREQ=MINUTELY; INTERVAL=15

如果您希望它在四分之一小时内准确运行，则此操作:

If you want it to run exactly on the quarter hour, then this:

FREQ=MINUTELY; BYMINUTE=0,15,30,45; BYSECOND=0

如果您希望它每天早上8点运行，请执行以下操作:

If you want it to run every day at 8am, then this:

FREQ=DAILY; BYHOUR=8; BYMINUTE=0; BYSECOND=0

这篇关于什么是"INTERVAL = 0"?在Oracle Schedular中意味着什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！