Re: DBMS_JOBS questions

first look at the initialization parameters job_queue_processes and job_queue_interval.
sencod the commit is necesesary.
Yo need at least one snmp process and i think that you dont need ';' after the procedure name;

"Amos" <amos_987_at_hotmail.com> escribió en el mensaje news:9bp87o$f$1_at_news.inter.net.il...
> Hi there,
>
> I used DBMS_JOBS with interval SYSDATE+1/24 to exec my proc every hour.
> In my SP I have an insert that includes sysdate so I can monitor the
> execution.
>
> EXEC SYS.DBMS_JOB.SUBMIT (out_job_id, 'MyPack.MyProc(x) ;' , SYSDATE,
> 'SYSDATE + 1/24' );
> But nothing happened ?? WHY ??
>
> Did I forget to do something? Who is responsible of doing the COMMIT ?
> Under which privileges the procedure is executed - the SP owner, SYSTEM or
> DBMS_JOBS owner?
>
> Is there a limit to the interval? (e.g can I schedule it to exec every 10
> min for my testing?)
>
> Cheers,
>
> Amos
>
>
>
Received on Fri Apr 20 2001 - 07:55:36 CDT