Re: DBMS_JOBS questions

If your procedure really expects a parameter you can't do that with dbms_job - who should provide that value (check your server's alert file). For monitoring your job use dd views dba_jobs / user_jobs and dba_jobs_running.

Klaus
Amos <amos_987_at_hotmail.com> schrieb in im Newsbeitrag: 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 - 09:30:11 CDT