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:
00945864
Views:
34
Yes, thats it. thanks.

>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
George
Previous
Reply
Map
View

Click here to load this message in the networking platform