Oracle jobs not picking the job up....9i
I have a number of Oracle jobs in a 9i db set up which can be seen to be running every second (1/86400) in 'Toad'. The CJQ0 process is also running as well as a number of jnnn processes on HPUX.
The jobs are supposed to pick a package up and run it but I can confirm they are doing that because I can't see any output from that package. If I run the package manually, it runs fine.
dba_queue_processes is set to 100.
Please could someone advise on what to check next? I was looking for a way to track the activity when an oracle job runs.