DBMS_Jobs - Urgent

[st2000]

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.

[st2000]

Following to the above scenario.. If anyone want to schedule more than 1 dbms_job, how is he going to do then??

[sreddy]

[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/jobq.htm#7997[/url]

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.