[Translated from MOS] solution to automatic job execution failure

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.