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博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-237889/ ，如需转载，请注明出处，否则将追究法律责任。
