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:
00945646
Vues:
35
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform