CREATE OR REPLACE PROCEDURE "SYSTEM"."" ( ALogType IN VARCHAR2, ALogHintType IN VARCHAR2, ALogPerson IN VARCHAR2, ALogEvent IN VARCHAR2, ALogData IN VARCHAR2, ASysPamams IN VARCHAR2, AMODCaption IN VARCHAR2) AS ADATE DATE; BEGIN SELECT SYSTEM INTO ADATE FROM dual;--把系统时间放进ADATE 然后用trigger编一个时间限制
ALogType IN VARCHAR2,
ALogHintType IN VARCHAR2,
ALogPerson IN VARCHAR2,
ALogEvent IN VARCHAR2,
ALogData IN VARCHAR2,
ASysPamams IN VARCHAR2,
AMODCaption IN VARCHAR2)
AS
ADATE DATE;
BEGIN
SELECT SYSTEM INTO ADATE FROM dual;--把系统时间放进ADATE
然后用trigger编一个时间限制
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'my_job',
job_type => 'STORED_PROCEDURE',
job_action => '你在存储过程名',
start_date => SYSDATE,
repeat_interval => 'FREQ=DAILY; INTERVAL = 1; BYHOUR=1', --如果想要在几点运行,就用BYHOUR=N,(N在0到24之间)
enabled => TRUE
);
END;
/