12.1.0.2
Have a scheduler job runs every 10 seconds. Calls a small package which run ins in 1-2 seconds. Have had a couple of instances recently where the job wont run. Its not that its running and failing or hanging, its not running at all.
Theres an oracle note that goes through some of the posible scenarios here like a job window or a second job disabling it, but none apply here.
Had an example this morning where it stopped running for about 20 minutes (nothing specific about the time) then started again, dba_scheduler_job_run_details shows that other jobs ran ok during this window.
This sounds to me like maybe it cant get a queue process, my job_queue_processes = 100.
Nothing in alert log.
Threads are at default 1 so no resource limiting.
Theres a known issue with 12.1.0.2 that auto statistics on table create uses a queue process and that may been causing it if we had a lot of table creations at the time, however we have DDL auditing on so we see thats not affecting us here.
Where else can I check to see if job_queues were affected and if thats not it what else could I look at?