Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_job question

dbms_job question

From: Jaehne, Richard S <JaehneRS_at_state.gov>
Date: Fri, 15 Apr 2005 14:08:26 -0400
Message-ID: <2BF02E41764FE640B254C590B169C85C06AF073B@MSWASHDCMB02.irm.state.gov>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 15 2005 - 14:14:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US