Oracle job interval rules

1. Execution per minute

Interval => TRUNC (sysdate, 'mi') + 1/(24*60)

Or

Interval = & gt; sysdate + 1/1440

2. daily scheduled execution

Example: Execute at every day

Interval => TRUNC (sysdate) + 1 + 5/(24)

3. scheduled weekly execution

For example, run the command at every Monday.

Interval => TRUNC (next_day (sysdate, 'monday') + 5/24

4. scheduled monthly execution

Example: Execute at on the first day of every month

Interval => TRUNC (LAST_DAY (SYSDATE) + 1 + 5/24

5. Periodical execution on a quarterly basis

For example, it is executed at on the first day of each quarter.

Interval => TRUNC (ADD_MONTHS (SYSDATE, 3), 'q') + 5/24

6. scheduled execution every six months

For example, at a.m. on July 1 and July 5

Interval => ADD_MONTHS (trunc (sysdate, 'yyyy'), 6) + 5/24

7. Regular annual execution

Example: Execute at on January 1, January 1 every year.

Interval => ADD_MONTHS (trunc (sysdate, 'yyyy'), 12) + 5/24