Oracle JOB interval Reference Analysis

Abstract: The following articles mainly involve the actual application of Oracle JOB interval reference.
If you are interested in the relevant content for the JOB interval reference, the following articles will help you.

Label: Oracle JOB

If you want to know the actual application solutions for Oracle JOB interval reference, you can view the following articles on Oracle
For details about the JOB interval, refer to the correct usage in actual operations.

If your stored procedure is named PROC_RAIN_JM

Write another Stored Procedure named PROC_JOB_RAIN_JM.

Content:

 

 
 

  
  
Create Or Replace Procedure PROC_JOB_RAIN_JM  
  
  
Is  
  
  
li_jobno Number;  
  
  
Begin  
  
  
DBMS_JOB.SUBMIT(li_jobno,'PROC_RAIN_JM;',
SYSDATE,'TRUNC(SYSDATE + 1)');  
  
  
End; 
 
 

 

The last item can be referenced as follows:

'Trunc (SYSDATE + 1) 'At midnight every day )'

Every morning 08:30 'trunc (SYSDATE + 1) + (8*60 + 30)/(24*60 )'

NEXT _ DAY (TRUNC (SYSDATE), ''tuesday'') + 12/24 at every TUESDAY'

'Trunc (LAST_DAY (SYSDATE) + 1) 'at midnight on the first day of each month )'

'Trunc (ADD_MONTHS (SYSDATE + 2/24, 3), 'q')-100' at on the last day of each quarter'

Every SATURDAY and 06:10 am 'trunc (LEAST (NEXT_DAY (SYSDATE, ''saturday "), NEXT_DAY (SYSDATE,
"SUNDAY") + (6*60 + 10)/(24*60 )'

In Oracle
For details about the JOB interval, li_jobno is its ID. You can stop this task by using this ID. The last thing you want to say is not to execute it multiple times. You can manage it in it, if it is already running, it will not be SUBMIT

Run 'sysdate + 1' every day'

Run 'sysdate + 1/24 'every hour'

Run 'sysdate + 10/(60*24) 'every 10 minutes )'

Run 'sysdate + 30/(60*24*60) 'every 30 seconds )'

Run 'sysdate + 7' once every week'

No longer run the task and delete it NULL

Every January 1

 
 

  
  
trunc(last_day(to_date(extract(year from sysdate)||'12'||'01','yyyy-mm-dd'))+1) 
 
 

The above content is the description of Oracle JOB interval reference, hoping to help you in this regard.

[Edit recommendations]

1. Description of the basic idea of Oracle Web Hacking
   
2. Oracle web Environment injection technology injection in the real world
   
3. How to set a password for the Oracle tnslsnr Server
   
4. Description of how to add Oracle Constraints
   
5. How to change the primary key of a table in Oracle