Re: Schedule a procedure doesn't work ?

Question: You did change init.ora's job_queue_processes and bounce the database? If you didn't you can just wait 4ever. You did commit after issuing dbms_job.submit? Otherwise same problem.

Regards,

Sybrand Bakker, Oracle DBA

On Fri, 20 Apr 2001 09:56:53 -0200, "Amos" <amos_987_at_hotmail.com> wrote:

>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 - 10:07:15 CDT