Hi All

Is there any way to decrease the polling interval that Oracle uses to
determine if there are jobs pending in the job queue.

It appears that it takes up to 5 seconds for a job to be executed
after it has been submitted via DBMS_JOB.SUBMIT.

If possible, would it adversely affect resources by decreasing this
interval?

Thanks
Ron

Oracle 9.2.0.4
RedHat Linux 7.3

Hi Ron,
You can increase the polling interval by executing the following SP
DBMS_JOB.INTERVAL
How long does your current job takes for execution.


Regards
Deven Saoji

RonGeorge (AT) hotmail (DOT) com (Sporge) wrote in message news:<7e3b24c7.0408230309.54f17316 (AT) posting (DOT) google.com>...