Hi

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.

Regards
Shajju