Oracle job timing execution parameters

Common execution time of oracle job

1. Execute every minute

Trunc (sysdate,'mi') + 1 / (24060)

2. Execute regularly every day

For example, it is executed at 0: 00 in the morning every day.

Trunc (sysdate+1)

Executed at 1: 00 a. M. every day

Trunc (sysdate+1) + 1 Compact 24

Executed at 08:30 every morning

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

3. Execute regularly every week.

Every Monday at 2: 00 a. M.

Trunc (next_day (sysdate,1)) + 2Acer 24

Every Tuesday at 12:00

Trunc (next_day (sysdate,' Monday')) + 12 Unix 24

4. Execute regularly every month

Implemented at 0: 00 a. M. on the 1st of every month

Trunc (last_day (sysdate) + 1)

Implemented at 1: 00 a. M. on the 1st of every month

Trunc (last_day (sysdate) + 1) + 1 Universe 24

5. regular execution on a quarterly basis

Executed at 0: 00 a. M. on the first day of every quarter

Trunc (add_months (sysdate,3),'q')

Executed at 2: 00 a. M. on the first day of every quarter

Trunc (add_months (sysdate,3),'q') + 2 Unix 24

Executed at 11:00 on the last night of every quarter

Trunc (add_months (sysdate+2/24,3),'q')-1 Universe 24

6. Regular execution every half a year

Every year at 1: 00 a. M. on January 1 and July 1

Add_months (trunc (sysdate,'yyyy'), 6) + 1 Unix 24

7. Regular execution every year

Executed at 2: 00 a. M. on January 1 every year

Add_months (trunc (sysdate,'yyyy'), 12) + 2 Unix 24