execute procedure automatically in oracle 9i
Am new to this forum,here I had a question of how to execute a stored procedure automatically for a specific time i tried it with dbms_job but it does not work.Please some body help me on this.
Last edited by davey23uk; 12-08-2009 at 01:32 PM.
if you dont say what the problem with dbms_job how is anyone supposed to help?
dbms_job is the correct solution
Originally Posted by mohansherk
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width