Re: Scheduling a Pl/Sql program

I have similar problem on OpenVMS, Oracle 7.3.2.3.0. Try to increase job_queue_processes in init.ora.

In my configuration works fine:
job_queue_processes = 2

Pepe Lima wrote in message <6ug486$3ha$1_at_diana.bcn.ibernet.es>...
>Hi,
>
>I have an Oracle7 Workgroup Server 7.2.2.4.6 for Netware,
>I need to execute a process every day and I complete this steps:
>
>- add to the init.ora file the parameters:
>
>job_queue_interval = 60
>job_queue_processes = 1
>
>- execute this code:
>
>declare
> l_job number;
>begin
> dbms_job.submit( l_job,
> 'estructura_acumulada.calcular_todos;',
> trunc(sysdate)+1+(5/24),
> 'trunc(sysdate)+1+(5/24) );
> commit;
>end;
>/
>
>this reports no errors, but it doesn't works !!!!
>
>Thanks for your time,
>
>Jose Lima
>lima_at_ensa.org
>ENSA, Vigo, Spain
>
>
>
Received on Mon Sep 28 1998 - 19:04:35 CDT