Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBMS_JOB.Submit doesn't work
Message
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00945588
Message ID:
00945646
Views:
37
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform