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

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

Re: dbms_job question

From: cichomitiko gmail <cichomitiko_at_gmail.com>
Date: Fri, 15 Apr 2005 20:15:48 +0200
Message-ID: <00a501c541e7$28005b50$2800a8c0@IBME1D11967173>


The syntax is:

exec <proc_name>;

es.

exec DBMS_JOB.S...

HTH
Dimitre

ETNěTEAM
----- Original Message -----
From: "Jaehne, Richard S" <JaehneRS_at_state.gov> To: <oracle-l_at_freelists.org>
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
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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

Original text of this message

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