When creating a job, where:
What -- stored procedure to be called during job execution;
Next date -- next job execution time;
Interval -- job execution interval. This parameter involves the value of next date. Next is calculated based on interval.
Interval:
1: executed 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 + 1/(24)
3: scheduled weekly execution
Example: Execute at every Monday
Interval => trunc (next_day (sysdate, 'monday') + 1/24
4: scheduled monthly execution
Example: Execute at on the first day of every month
Interval => trunc (last_day (sysdate) + 1 + 1/24
5: Periodical execution on a quarterly basis
For example, the statement is executed at on the first day of each quarter.
Interval => trunc (add_months (sysdate, 3), 'q') + 1/24
6: scheduled execution every six months
For example, at a.m. on January 1, July 1 and January 1, January 1
Interval => add_months (trunc (sysdate, 'yyyy'), 6) + 1/24
7: scheduled execution every year
Example: Execute at on January 1, January 1 every year.
Interval => add_months (trunc (sysdate, 'yyyy'), 12) + 1/24