Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Schedule a procedure doesn't work ?
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