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

Home -> Community -> Usenet -> c.d.o.tools -> Schedule a procedure doesn't work ?

Schedule a procedure doesn't work ?

From: Amos <987_at_hotmail.com>
Date: Fri, 20 Apr 2001 09:56:53 -0200
Message-ID: <9bomiv$t18$1@news.inter.net.il>

Thanks for the answers,
I used DBMS JOBS with interval SYSDATE+1/24 to perform the SP every hour.

EXEC SYS.DBMS JOB.SUBMIT (out job id, 'MyPack.MyProc(x) ;' , SYSDATE, 'SYSDATE + 1/24' );
In MyProc In put an insert so I could trace the job - BUT nothing happened ?? WHY ??

Cheers,

Amos

"Amos" <amos 987_at_hotmail.com> wrote in message news:9bmahl$3ht$1_at_news.inter.net.il...
> Hi,
>
> I wrote a procedure which I want to automatically execute 3 times a
 day.
> There must be a package that will let me create a scheduled job.
>
> How do I do it ??
>
>
> Amos
>
>

--
Received on Fri Apr 20 2001 - 06:56:53 CDT

Original text of this message

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