Re: DBMS_JOBS questions

No, the ";" is required after the name

David Richardson

"Ibán Díaz Solé" wrote:

> 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 Sun Apr 22 2001 - 04:37:12 CDT