User job isn't working

Hi gurus,

I'm reading the list for a long time and found a lot of useful ideas in your answers
(and in questions, too :-). I hope someone can help me in the following problem.

'MyProc' is a very simple procedure:

create or replace procedure MyProc is
begin

   insert into MyTable values (sysdate, 10); commit; end MyProc;

After executing the

   dbms_job.submit( x, 'MyProc;', sysdate+2/24/60, 'sysdate+2/24/60' ); command, my job shows itself in the sys.user_jobs view - but nothing else.

The value of 'job_queue_processes' initialization parameter is 5.

Please help, what am I to do?
Thanks in advance! Received on Fri Jul 21 2000 - 15:25:57 CDT