Re: Schedule a procedure doesn't work ?

Thanx, I changed the job_queue_processes and it works now.

Do I have to run : ALTER SYSTEM ENABLE RESTRICTED SESSION; as well ?? I read that SNP background processes will not execute jobs if the system has been started in restricted mode. is it relevant for me?

Cheers,
Amos

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:92k0etkefq9jfvvd4oorerujdmhgbaprkr_at_4ax.com...
> 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 Sat Apr 21 2001 - 08:15:24 CDT