Common execution time of oracle jobs 1. Execute TRUNC (sysdate, 'mi ') + 1/(24*60) www.2cto.com every minute. 2. Perform regular execution every day for example: TRUNC (sysdate + 1) is executed at 08:30 every day. TRUNC (sysdate + 1) + 1/24 is executed at every morning) + (8*60 + 30)/(24*60) 3. scheduled weekly execution. For example, perform TRUNC (next_day (sysdate, 1) At every Monday )) + 2/24 TRUNC (next_day (sysdate, 'monday') + 2/24 TRUNC (next_day (sysdate, 2) + 12/24 TRUNC (next_day (sysdate, (Tuesday) + 12/24 4. scheduled execution every month. For example, TRUNC (LAST_DAY (SYSDATE) + 1) is executed at on the first day of each month) execute TRUNC (LAST_DAY (SYSDATE) + 1) + 1/24 at on the first day of each month, and regularly execute TRUNC (ADD_MONTHS (SYSDATE, 3), 'q') perform TRUNC (ADD_MONTHS (SYSDATE, 3), 'q') at on the first day of each quarter ') + 2/24 perform TRUNC (ADD_MONTHS (SYSDATE + 2/24, 3), 'q')-1/24 on the evening of the last day of each quarter. 6. Perform regular execution every six months, for example: execute ADD_MONTHS (TRUNC (sysdate, 'yyyy'), 6) + July 1 at on January 1, January 1 and 1/24 every year. Example: execute ADD_MONTHS (TRUNC (sysdate, 'yyyy'), 12) + January 1 at on January 1, 2/24 every year.