Scheduling a Pl/Sql program

From: Pepe Lima <lima_at_ensa.org>
Date: Fri, 25 Sep 1998 15:04:32 +0200
Message-ID: <6ug486$3ha$1@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 Fri Sep 25 1998 - 08:04:32 CDT