Re: Scheduling a Pl/Sql program

How did you verify it doesn't work? Did you check the user_jobs dictionary view? Jobs that fail will be repeated 16 times until they are considered broken (separate column in the view). In your pl/sql code I see a redundant ; and a redundant ' in the call to dbms_job.submit. Chances are dbms_job is very uncritical to the params it is getting and discovering the problem will be postponed until the job is going to run.

Hope this helps,

Sybrand Bakker, Oracle DBA

In article <6ug486$3ha$1_at_diana.bcn.ibernet.es>, "Pepe Lima" <lima_at_ensa.org> wrote:
>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 - 16:08:27 CDT