Oracle Job Timing Execution Parameters

Common execution time for Oracle job

1. Execute Every Minute

Trunc (sysdate, ' mi ') +1/(24*60)

2, daily scheduled execution

such as: daily 0 o'clock in the morning execution

Trunc (sysdate+1)

Performed 1 o'clock in the morning daily

Trunc (sysdate+1) +1/24

Performed 8:30 A.M. daily

Trunc (sysdate+1) + (8*60+30)/(24*60)

3. Regular weekly execution

Executed every Monday 2 o'clock in the morning

Trunc (Next_day (sysdate,1)) +2/24

Executed every Tuesday noon 12 o'clock

Trunc (Next_day (sysdate, ' Monday ')) +12/24

4. Regular monthly execution

1st 0 o'clock in the morning monthly execution

Trunc (Last_day (sysdate) +1)

1st 1 o'clock in the morning monthly execution

Trunc (Last_day (sysdate) +1) +1/24

5, quarterly scheduled execution

0 o'clock in the morning execution of the first day of the quarter

Trunc (Add_months (sysdate,3), ' Q ')

2 o'clock in the morning execution of the first day of the quarter

Trunc (Add_months (sysdate,3), ' Q ') +2/24

Every quarter of the last day of the Night 11 o'clock execution

Trunc (Add_months (sysdate+2/24,3), ' Q ') -1/24

6, every half-yearly scheduled execution

1 o'clock in the morning each year on January 1 and July 1

Add_months (Trunc (sysdate, ' yyyy '), 6) +1/24

7. Scheduled execution every year

Executed on January 1 2 o'clock in the morning each year

Add_months (Trunc (sysdate, ' yyyy '), 12) +2/24

Oracle Job Timing Execution Parameters