It sounds like you are issuing 'dbms_job.submit(...)' from the SQL = prompt. The easiest way to do this would be to issue the command using = an anonymous PL/SQL block. =20 ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jaehne, Richard S Sent: Friday, April 15, 2005 12:08 PM To: oracle-l@xxxxxxxxxxxxx Subject: dbms_job question All,=20 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,=20 Richard Jaehne -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l