execute dbms_job.submit( -
   what=>'update_stock;',  -
   next_date=>sysdate+3/24, -
   interval=>'sysdate+3/24');

commit;


bw


--- In [email protected], fan...@... wrote:
>
> Hello indo-oracle,
> 
>   mau tanya bagaimana caranya bikin schedule, tiap 3 jam sekali
>   melakukan call procedure
>   misanya nama procedure nya update_stock.
>   tks
> 
> -- 
> Best regards,
> fansul
> mailto:fan...@...
> 
> __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam?  Surat Yahoo! memiliki perlindungan terbaik terhadap 
> spam  
> http://id.mail.yahoo.com
>


Kirim email ke