When defining an oracle scheduled task, the interval is defined as the end time of a task to the start time of another task.
When defining an oracle scheduled task, the interval is defined as the end time of a task to the start time of another task.
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 to the next execution time of each calculation, that is, the execution time of the task 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