How To Schedule A Job From Procedure ?

How To Schedule A Job From Procedure ?

 

  

Hi All ,

I have a schedule a procedure , now question is can we change the job scheduling from another procedure . For eg my_proc is schedule every day at midnight. Can i change this schedule from a procedure through Dynamic SQL , If yes ? Can some one send me the excat syntax how to run DBMS_JOB from Dynamic SQL .

TIA
Pradeep


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
Oracle LazyDBA home page