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 when > I try to submit the job in SQL is this: SP2-0734: unknown command > beginning "DBMS_JOB.S..." - rest of line ignored. From the error message I guess you're not putting the 'EXECute' command infront of your call to DBMS_JOB... Stephen --=20 It's better to ask a silly question than to make a silly assumption. -- //www.freelists.org/webpage/oracle-l