Re: dbms_job question

  • From: "cichomitiko gmail" <cichomitiko@xxxxxxxxx>
  • To: <JaehneRS@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Apr 2005 20:15:48 +0200

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

Other related posts: