Oracle job interval parameter setting example

The Oracle job interval parameter settings still account for the majority of applications. If you are curious about this technology, the following articles will unveil its mystery. The materials I saw on the relevant website two days ago are quite good. I will share them with you.

1: executed per minute

 
 

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

Or

 
 

  
  
Interval => 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: scheduled execution per quarter in Oracle job interval parameter settings

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 
 
 

The above content describes the actual operation steps for setting the Oracle job interval parameter, hoping to help you in this regard.