17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> create table t(idx int);
Table created
SQL>
SQL> create or replace procedure rgl_b_rjl_proc
2 is
3 begin
4 insert into t values(1);
5 commit;
6 end;
7 /
Procedure created
SQL>
SQL> variable job number;
SQL> begin
2 sys.dbms_job.submit(job => :job,
3 what => 'rgl_b_rjl_proc;',
4 next_date => to_date('18-09-2008 10:06:41', 'dd-mm-yyyy hh24:mi:ss'),
5 interval => 'sysdate+1/1440');
6 commit;
7 end;
8 /
PL/SQL procedure successfully completed
job
---------
1
SQL> select * from dba_jobs;
JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- -------------------------------- ----------- -------------------------------- ----------- -------------------------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
1 SYS SYS SYS 9/18/08 10: 10:39:46 9/18/08 10: 10:40:46 0 N sysdate+1/1440 0 rgl_b_rjl_proc; NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENC 0102000202000000 0
SQL> select * from dba_jobs;
JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- -------------------------------- ----------- -------------------------------- ----------- -------------------------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
1 SYS SYS SYS 9/18/08 10: 10:39:46 9/18/08 10: 10:40:46 0 N sysdate+1/1440 0 rgl_b_rjl_proc; NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENC 0102000202000000 0
SQL> exec dbms_job.run(1);
PL/SQL procedure successfully completed
SQL> select * from t;
IDX
---------------------------------------
1
1
SQL> select * from t;
IDX
---------------------------------------
1
1
SQL> select * from t;
IDX
---------------------------------------
1
1
1
SQL>