Re: ORACLE JOBS

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1997/01/31
Message-ID: <32F1A9E2.37CC@adra.se>#1/1

Etienne F de Villiers wrote:
> #
> # declare
> # jobnum number;
> # begin
> #
> dbms_job.submit(jobnum,'get_db_freespace',sysdate,'sysdate+(1/24/60*5)',null

                          ||||||||||||||||
------------------------------------------

This may be the problem.

> );
> # end;
> #
> WHAT CAN BE WRONG WITH MY JOBS?
Maybe you should do:
dbms_job.submit (
  jobnum,
  'begin get_db_freespace; end;',
  sysdate,
  'sysdate+(1/24/60*5)',
  null);
Just a thought.

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.

Received on Fri Jan 31 1997 - 00:00:00 CST