--最多同時(shí)運(yùn)行的JOB個(gè)數(shù)；如果太小，JOB就排隊(duì)等待；如果為0，就沒(méi)有JOB會(huì)被執(zhí)行。
SQL> show parameter job_queue_processes
NAME??????????????????????????????????????? TYPE????????? VALUE
--------------------------???????? ----------??? -------------
job_queue_processes???????? integer ?? ????? 10
--一個(gè)什么也不做的SP
CREATE OR REPLACE PROCEDURE mytest
IS
BEGIN
?? ?NULL;
END;
--一個(gè)往表里寫(xiě)數(shù)據(jù)的SPCREATE OR REPLACE PROCEDURE mytest
IS
BEGIN
?? ?insert into test_table values(...);
END;
--定時(shí)調(diào)用SP，10秒（86400秒=1天）SQL> VARIABLE job_id NUMBER;
SQL> BEGIN
??????????
-- :job_id中的冒號(hào)表示冒號(hào)后面的是變量，類(lèi)似SQL Server的@?????????? DBMS_JOB.SUBMIT(:job_id, 'mytest;', sysdate, 'sysdate + 10 / 86400') ;
?????????? COMMIT;?
--記得一定要commit哦?????????? END;
--查看剛才生成的Job IDSQL> set serveroutput on
SQL> execute dbms_output.put_line(:job_id)?
--這里倒是不需要commit，直接execute就好了318--查看所有Job?select * from user_jobs;
--刪除JobSQL> BEGIN
?????????? DBMS_JOB.REMOVE(123); --123是Job ID
?????????? COMMIT;
?????????? END;
如果Job由于某種原因未能成功運(yùn)行，Oracle將重試16次，之后如果還未能成功運(yùn)行，將被標(biāo)記為Broken。
http://m.tkk7.com/Jcat/archive/2009/12/17/306315.html
從10g開(kāi)始，DBMS_SCHEDULER 逐步會(huì)替換掉 DBMS_JOB
DBMS_JOB has been around forever, and now it is deprecated. Although DBMS_JOB still exists in 10g and 11g, but only for backward compatibility. No new features are being added to dbms_job and you will likely quickly run into its limitations. Oracle recommends the use of DBMS_SCHEDULER in releases 10g and up. DBMS_SCHEDULER is a much more robust package and fully-featured than DBMS_JOB. To use the DBMS_SCHEDULER package a user must be granted the CREATE JOB privilege.
After replace DBMS_JOB with DBMS_SCHEDULER for all jobs successful, the job_queue_processes parameter can now be set to zero.
SQL> alter system set job_queue_processes=0;
posted on 2009-04-16 15:42
Jcat 閱讀(782)
評(píng)論(0) 編輯 收藏 所屬分類(lèi):
Database