Re: dbms_job question

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Fri, 15 Apr 2005 14:18:15 -0400
Message-ID: <f8c47710504151118ec1a460@mail.gmail.com>

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_at_gmail.com> wrote:

> On 4/15/05, Jaehne, Richard S <JaehneRS_at_state.gov> 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_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 15 2005 - 14:22:18 CDT