Analysis and solutions to the reasons why Oracle scheduled task timing is invalid

This article brings you relevant knowledge about Oracle. It is found that the system data has not been updated. Check the oracle scheduled task and it is estimated that it has not been executed. The following is an analysis of the reasons why the oracle scheduled task timing is invalid. and solutions, hope it helps everyone.

Recommended tutorial: "Oracle Video Tutorial"

Creating oracle scheduled tasks The scheduled tasks are not executed on time

Since the project needs to synchronize other system databases, after creating the dblink and stored procedures, a new dbm_job task was created. When I was fully expecting to get off work early, I found that the scheduled task was not executed according to the time.

Create a scheduled task JOB(63) The scheduled task is not executed

Cause analysis:

Maybe the database does not have the function of JOB Turn it on, so we lead in this direction to find a solution.

Solution:

After consulting the information, I found that there is a parameter job_queue_processes with a number of 0, which means that scheduled tasks will not be executed. The query SQL is as follows:

select value from v$parameter where name like '%job_queue_processes%';

Modify the parameter job_queue_processes Greater than 0, I set it here to 10 (you can increase it appropriately)

alter system set job_queue_processes =10;

Retest again:

Supplement: The parameter job_queue_processes seems to be a scheduled task queue process. I checked the information and added the following:

1. The value range of job_queue_processes is 0 to 1000. The total number of job processes that can be created is determined by the job_queue_processes parameter.

2. When job_queue_processes is greater than 1, and when jobs are executed in parallel, at least one is a coordinating process. The total number will not exceed the value of job_queue_processes.

3. The value of the job_queue_processes parameter is and DBMS_JOB is shared with DBMS_SCHEDULER.

4. Job_queue_processes parameter, when the value is set to 0, jobs created in any way will not run.

5. For non-zero value job_queue_processes, the number of job sub-processes depends on the available resources, resource configuration method and the number of currently running jobs.

6. In addition, the Scheduler jobs method is also limited by the setting of the scheduler attribute MAX_JOB_SLAVE_PROCESSES.

7. You can set max_job_slave_processes through DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of Analysis and solutions to the reasons why Oracle scheduled task timing is invalid. For more information, please follow other related articles on the PHP Chinese website!