【翻譯自mos文章】job 不能自動執行的解決方案，mosjob

【翻譯自mos文章】job 不能自動執行的解決方案，mosjob
job 不能自動執行的解決方案

參考原文：
Jobs do not execute automatically (Doc ID 309945.1)


適用於：
Oracle Server - Enterprise Edition - Version: 9.2.0.4
This problem can occur on any platform.


癥狀：
Job 不能自動執行。
JOB_QUEUE_PROCESSES 已經設定為大於0的值

你已經檢查過 sga 變數kkjsre 的值，該值為0

例子：

SQL> CONN SYS/*********** AS SYSDBA
Connected.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug  dumpvar sga kkjsre
word kkjsre_ [20B7480, 20B7484) = 00000000

原因：

讓job 能自動運行，sga變數kkjsre必須為1

取消正在shutdown的過程（Canceling a shutdown in progress ） 是 這個變數值為0的一個原因。

解決方案：

1)以sys登陸

2) 執行下面的命令：

SQL> exec  dbms_ijob.set_enabled(true);

3) 驗證 kkjsre 是否被設定為 1

SQL> oradebug setmypid
Statement processed.
SQL> oradebug  dumpvar sga kkjsre
word kkjsre_ [20B7480, 20B7484) = 00000001


4) 確認job 開始自動運行。如果沒有，重啟db，並再次檢查kkjsre的值，該值應該為1,然後job應該可以自動執行了。


Oracle job為何不可以自動執行，手工執行可以

用sysdba登入，執行show parameter job_queue_process看看結果是不是0
如果是這個原因，可以修改此參數
ALTER SYSTEM SET job_queue_processes = 10;
 
翻譯成英文“my first job”詞彙4級左右文章在補充欄，重新整理

My first job was in the supermarket do sophomore Thomas j. Lipton promotions. After I finished on the morning of 4 lessons quickly after lunch, and then cycle to school near the large supermarkets, change of clothes, runs from 1 o'clock in the afternoon until 9 o'clock at night, a total of 8 hours daily wage was $ 60. Work is at the entrance to the supermarket to sell current customers stand various flavors of product, I offer free tasting and inventory the containers and on the shelves. Working time has been standing status, but also in rigid work shoes and don't stop to call to their customers, 8-hour taste of lumbar back pain, a nasty ingrown toenail. Work at 9 o'clock at night after the end, I have to get back to the school, professional classroom completion of course work in the morning, often to get 11 points before the bedroom door had to end. Although every day is busy, but yourselves better than every day afternoon sleep in the bedroom, as well as salary. Of course, the biggest effect is that I have guts to get bigger, you know that until I did not dare to so many strangers talk so loud.
這些有的是我自己的