dbms_job

[dave777]

did you issue commit after submit?

[jtanders]

Yep. I've tried it with the commit in the block, out of the block, both in and out of the block. I've tried it every way that I can think of and can't ever get the thing to run on it's own.

[svk]

jtanders,

There is a reported bug [BUG:328164] that is : "DBMS_JOB WILL NOT EXECUTE A PROCEDURE IF PUT IN THE JOB QUEUE
BY ANOTHER."

Pl see if you are being hit by this.....

[patnams]

does your job take more time than the job interval ??

[jtanders]

does your job take more time than the job interval ??

No.

There is a reported bug [BUG:328164] that is : "DBMS_JOB WILL NOT EXECUTE A PROCEDURE IF PUT IN THE JOB QUEUE
BY ANOTHER."


That particular bug does not apply however, I found another one that may (Bug 1930074). It seems to be a problem with 'alter system disable restricted'. Apparently, if the instance was started in restricted mode then the statement “alter system disable restricted session” was issued, the problem arises. If you shutdown the database and startup normal the problem should go away. I haven’t had a chance to shutdown the database yet so I can’t confirm this but, I believe this is where the problem lies because the instance was brought up “restricted”.
I will post again if I find something different.