Oracle jobs can be executed manually and cannot be performed automatically

Oracle job can also be executed automatically before it is automatically executed?

View Oracle's job process through Ps-ef |grep Ora_j, no related job process found;

[Email protected] ~]$ Ps-ef |grep Ora_j
Oracle 13527 24508 0 15:13 pts/4 00:00:00 grep ora_j

View All_jobs view for details such as the job's last execution time and the next execution time

Select Log_user,priv_user,schema_user,last_date,next_date,broken,interval from all_jobs where broken= ' N ';

Log_user	Priv_user	Schema_user	Last_date	Next_date	Broken	Interval
test	test	2015/11/16 15:23	2 015/11/16 15:24	n	sysdate+1/(24*60)
test	test	2015/11/16 15:18	2 015/11/16 15:28	n	sysdate+10/1440
test	test	2015/11/16 15:24	2 015/11/16 15:29	n	sysdate+5/(24*60)

Found that JOBS was not interrupted, and that the related job was not stuck through dba_jobs_running.

Job still cannot be performed automatically by viewing the current database's job_queue_processes also greater than 0

Sql> Show Parameter Job

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Job_queue_processes Integer 10

It was later found to be caused by modifying the OS time zone. Workaround:

1. Restart the database.

2. Modify the OS time zone, modify the system times, and re-execute the job.

Oracle jobs can be executed manually and cannot be performed automatically