Re: dbms_job question

Since dbms_job.submit takes an OUT parameter, you have to run it in an
anonymous block, like this:

variable jobno number
begin
  dbms_job.submit(:jobno, 'dba$alert.check_nightly_backup;',sysdate,
'trunc(sysdate) + 31/24');
  commit;
end;
/


On 4/15/05, stephen booth <stephenbooth.uk@xxxxxxxxx> wrote:
> On 4/15/05, Jaehne, Richard S <JaehneRS@xxxxxxxxx> wrote:
> > All,
> > I need to schedule a job to run weekly at a specific time.  I want to
> > use DBMS_JOB to run it but I'm having some issues.  The error I get whe=
n
> > I try to submit the job in SQL is this: SP2-0734: unknown command
> > beginning "DBMS_JOB.S..." - rest of line ignored.


--=20
Paul Baumgartel
paul.baumgartel@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: