I have a job that does not run automatically. It runs fine when I execute dbms_job.run(); but it never runs on the "next_date". After executing with dbms_job.run the next_date looks correct but it never runs.
The init.ora file has the following settings:
job_queue_processes = 2
job_queue_interval = 10
Here is the job:
'SYSDATE + 10/1440'
I'm baffled! Dave, I did exactly what you did (except I modified the update statement for my use) and it is still not executing. I can run the job manually (dbms_job.run) but it will not run by itself.
Whats you "job_queue_processes" init parameter value ?
And snp processes are just like other database daemons like PMON,SMON. So, you should be able to see if ora_snp is running.
If not (job_queue_processes is set to zero), change the value to at least 1. You don't need to bounce the database to do this. You can say "alter system set job_queue_processes=1" and the daemon will start.