学习oracle系统包－DBMS_JOB

1.创建job。

SQL> conn scott/tiger
Connected.
SQL> var jobno number
SQL> begin
  2  dbms_job.submit(:jobno,
  3  'dbms_ddl.analyze_object(''TABLE'',
  4  ''SCOTT'',''EMP'',''COMPUTE'');',
  5  SYSDATE,'SYSDATE+1/1440');
  6  COMMIT;
  7  END;
  8  /
 
PL/SQL procedure successfully completed.
 
SQL> PRINT JOBNO
 
     JOBNO
----------
        43

SQL> select job,LAST_DATE,THIS_DATE,TOTAL_TIME,INTERVAL,what from user_jobs;
 
       JOB LAST_DATE           THIS_DATE           TOTAL_TIME INTERVAL   WHAT
---------- ------------------- ------------------- ---------- ---------- --------------------------------------------------
        43 2008-04-15 15:35:17                              1 SYSDATE+1/ dbms_ddl.analyze_object('TABLE',
                                                              1440       'SCOTT','EMP','COMPUTE');

2.移除job
 

使用过程 DBMS_JOB.REMOVE(job in BINARY_INTEGER)；

3.修改job相关信息。

修改job的执行间隔为1天
SQL> exec dbms_job.change(43,null,null,'SYSDATE+1');
 
PL/SQL procedure successfully completed.

4.运行job

SQL> exec dbms_job.run(43);
 
PL/SQL procedure successfully completed.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10972173/viewspace-237889/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10972173/viewspace-237889/