【翻译自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应该可以自动执行了。
用sysdba登录，执行show parameter job_queue_process看看结果是不是0
如果是这个原因，可以修改此参数
ALTER SYSTEM SET job_queue_processes = 10;
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.
这些有的是我自己的