天萃荷净
分享一篇关于Oracle DBMS_SCHEDULER详细介绍与使用案例
1.通过DBMS_SCHEDULER.CREATE_JOB直接创建job
SQL> create table t_oracleplus (x_type varchar2(10),x_date date);
表已创建。
SQL> begin
2 DBMS_SCHEDULER.create_job (
3 job_name => 'f_create_job',
4 job_type => 'PLSQL_BLOCK',
5 job_action => '
6 begin
7 insert into t_oracleplus values(''job'',sysdate);
8 commit;
9 end;
10 ',
11 enabled => true,
12 start_date => SYSTIMESTAMP,
13 repeat_interval => 'SYSTIMESTAMP + 1/1440',
14 comments => 'oracleplus_create_job');
15 END;
16 /
SQL> select x_type,to_char(x_date,'yyyy-mm-dd hh24:mi:ss') from t_oracleplus;
X_TYPE TO_CHAR(X_DATE,'YYY
---------- --------