DBMS_JOBS questions

From: Amos <amos_987_at_hotmail.com>
Date: Fri, 20 Apr 2001 14:57:25 -0200
Message-ID: <9bp87o$f$1@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 - 11:57:25 CDT