Oracle scheduled task interval

When defining an Oracle scheduled task, the interval is defined as the end time of a task to the start time of another task.

Example: select (TRUNC (sysdate, 'mi') + 1/(24*60), (sysdate + 1/(24*60) from dual

Error: sysdate + 1/(24*60) is used as the time interval. In this way, the current time is added when the next execution time is calculated, that is, the task execution time is added.

Correct: TRUNC (sysdate, 'mi') + 1/(24*60), and trunc is used to ignore the error of the current time (that is, the extra time of the task ). First of all, we need to have a consensus that the execution time of a task by minute cannot exceed one minute, and the execution time of a task by hour cannot exceed one hour, the execution time of daily tasks cannot exceed one hour. In this way, we can use trunc to boldly ignore the hour: TRUNC (sysdate, 'hh24') + 1/24, Day: TRUNC (sysdate, 'dd') + 1