Re: dbms_job question
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Apr 2005 14:18:15 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
