Hi to all, I have a problem with my jobs, are scheduled but are not running, I need to run it manually and automatically update the next_date but jobs doesn't run again in all my DB instance. I try to enable/disable but stil the same. I can see my jobs but
When I run manually this update next date but this dont run.
This happen in a whole instance.
To resolve this issue, you have investigated and find the solution, check the below-mentioned list in your environment.
1. job_queue_processes may be too low
2. max_job_slave_processes may be too low
3. Sessions may be too low
4. Check if the Scheduler has been disabled
5. Examine the alert log to see if there are any errors. If the database is having issues allocating memory, has run out of disc space, or has had any other catastrophic failures.
6. Try restarting the scheduler
You can also check below article to Scheduling Jobs with DBMS_SCHEDULER
Thanks. for your help.