[Translated from mos] the solution for job cannot be automatically executed, mosjob
Solution to job failure
Reference Original:
Jobs do not execute automatically (Doc ID 309945.1)
Applicable:
Oracle Server-Enterprise Edition-Version: 9.2.0.4
This problem can occur on any platform.
Symptoms:
The Job cannot be executed automatically.
JOB_QUEUE_PROCESSES has been set to a value greater than 0
You have checked the value of the sga variable kkjsre. The value is 0.
Example:
SQL> CONN SYS/*********** AS SYSDBA
Connected.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga kkjsre
Word kkjsre _ [20B7480, 20B7484) = 00000000
Cause:
Make the job run automatically. The sga variable kkjsre must be 1.
Cancelling the shutdown process (Canceling a shutdown in progress) is one reason for the variable value to be 0.
Solution:
1) log in as sys
2) execute the following command:
SQL> exec dbms_ijob.set_enabled (true );
3) Verify that kkjsre is set to 1
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga kkjsre
Word kkjsre _ [20B7480, 20B7484) = 00000001
4) Confirm that the job starts to run automatically. If no, restart the database and check the value of kkjsre again. The value should be 1, and then the job can be automatically executed.
Why can't Oracle jobs be executed automatically or manually?
Log On With sysdba and run show parameter job_queue_process to check whether the result is 0.
If this is the reason, you can modify this parameter.
Alter system set job_queue_processes = 10;
In the supplement column, refresh
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 launch current MERs stand varous 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 MERs, 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 far.
These are my own.