The syntax is: exec <proc_name>; es. exec DBMS_JOB.S... HTH Dimitre ETNØTEAM ----- Original Message ----- From: "Jaehne, Richard S" <JaehneRS@xxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, April 15, 2005 8:08 PM Subject: dbms_job question > 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 when > I try to submit the job in SQL is this: SP2-0734: unknown command > beginning "DBMS_JOB.S..." - rest of line ignored. > > I've tried it with Oracle 8i and 9i both with the same results. > Shouldn't the DBMS_JOB scheduler be loaded by default? > > Any help would be appreciated. > > Thank you, > > Richard Jaehne > > > > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l