execute procedure automatically in oracle 9i

hi everybody,

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.

if you dont say what the problem with dbms_job how is anyone supposed to help?

dbms_job is the correct solution

Quote:

---

Originally Posted by mohansherk

i tried it with dbms_job but it does not work

---

fix it :D