Hi,
Check job_queue_processes as follows:
SQL> sho parameters job
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 0
2) If this is 0 then set it using:
alter system set job_queue_processes=30;
I bet that's it, FYI it means your system allows 0 consequtive dms_jobs to run.
BR
Tim
>Hello. I am attempting to use DBMS_JOB with 8i. I am using the following commands to try to immediately start a job. The job is added to the queue but does not start. Is there something I am missing?
>
> DBMS_JOB.submit(l_job, 'pr_test;', SYSDATE);
> COMMIT;
>
>Thanks