Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Schedule a procedure doesn't work ?

Re: Schedule a procedure doesn't work ?

From: Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de>
Date: Fri, 20 Apr 2001 09:33:37 +0200
Message-ID: <9boon9$aborl$1@ID-13717.news.dfncis.de> 








EXEC SYS.DBMS_JOB.SUBMIT (out_job_id, 'MyPack.MyProc(x) ;' , SYSDATE,
'SYSDATE + 1/24' );



In MyProc In put an insert so I could trace the job - BUT nothing happened
??  WHY ??


Did you commit it?


Is job_queue_processes set to more than zero?



hth,


Uli
Received on Fri Apr 20 2001 - 02:33:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US