Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBMS_JOB.Submit doesn't work
Message
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00945588
Message ID:
00945864
Vues:
33
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform