-
Oracle jobs not picking the job up....9i
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|