Oracle job can be executed manually but cannot be executed automatically

Oracle job can be executed manually but cannot be executed automatically
Oracle jobs can be automatically executed before, but cannot be automatically executed later? Run ps-ef | grep ora_j to view the oracle job process. No related job process is found. [oracle @ ncb1dg ~] $ Ps-ef | grep ora_joracle 13527 24508 0 00:00:00 pts/4 grep ora_j view all_jobs View details such as the last execution time and next execution time of a job 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 comment PM + N sysdate + 1/(24*60) test N SYSDATE + 10/1440 test 2015/11/16 55/11/16 N sysdate + 5/(24*60) It is found that jobs are not interrupted, and there is no hang to check related jobs through DBA_JOBS_RUNNING. By checking that the current database's job_queue_processes is greater than 0, the job still cannot automatically execute the SQL> show parameter jobNAME type value =-------------------------------- job_queue_processes integer 10 and later finds that the OS Time Zone has. Solution: 1. Restart the database. 2. Modify the OS time zone, modify the system time, and re-execute the job.