-
I have a db that is set up with replication evironment and has some db_links. So we have Job_queue_process=1 and Job_queue_interval=5 already set up.. Everything works fine.
Now I want to schedule a procedure that is run every minute and I used DBMS_Jobs for that. But though the frequency mentioned is 1 minute, still the procedure kicks of every 6th second, reason being the Job_queue_interval=5 in pfile..
I need that to be at 5 and as well have this procedure kick off every minute or so.. How do I do it??? Thx.
-
Following to the above scenario.. If anyone want to schedule more than 1 dbms_job, how is he going to do then??
-
http://technet.oracle.com/docs/produ.../jobq.htm#7997
Follow the link Read the documentation see the syntax of job excecution interval and Change it accordingly.
I could give specifics, sorry I am outta time.
