Oracle job can be executed manually but not automatically

Oracle job can be executed automatically before, but not later?

Check the job process of oracle through ps-ef | grep ora_j, but no related job process is found.

[oracle@ncb1dg ~] $ps-ef | grep ora_j

Oracle 13527 24508 0 15:13 pts/4 00:00:00 grep ora_j

View the all_jobs view to view details such as the last execution time and the next execution time of job

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

Log_userpriv_userschema_userlast_datenext_datebrokenintervaltesttesttest2015/11/16 15Grou232015Accord 11 15:24Nsysdate+1/ (24x60) testtesttest2015/11/16 15 testtesttest2015/11/16 182015lash 11peg 16 15:28NSYSDATE+10/1440testtesttest2015/11/16 15Rod 242015Accord 11 15:29Nsysdate+5/ (24x60)

It is found that there is no interruption in jobs, and there is no hang to check the relevant job through DBA_JOBS_RUNNING.

By checking that the job_queue_processes of the current database is also greater than 0, job still cannot be executed automatically.

SQL > show parameter job

NAME TYPE VALUE

-

Job_queue_processes integer 10

It was later discovered that it was caused by changing the OS time zone. Solution:

1. Restart the database.

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