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