Re: dbms_job question

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