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

check dba_jobs and the alert log

Thanks.

dba_jobs shows the jobs that are configured. And the alert log doesn't contain any info about the jobs.

look at the last run and next run dates

The Last and Next run dates are being updated regularly. Would you agree that the jobs are really running? Is there any way to see what an oracle job does i.e., pick the package it is supposed to run?

look into the "what" column in dba_jobs and check what the underlying procedure / package is doing.

Thanks,

...and, if you still don't trust what you see make underlying package/procedure to write a detailed log.

That's what I can't understand. Why the job cannot call the package, it is supposed to call!!!!!!!!!!!!!:confused:

That's what I can't understand. Why the job cannot call the package, it is supposed to call!!!!!!!!!!!!!:confused:

Please please guide me how to get the job to log what is happening when it runs.!!!!!

how do you know that the job is not calling the package?? Is that package generating any log? if not please read the post from PAVB and make the package to write a detailed log.

by the way what is the value of job_queue_processes parameter?

Thanks,

job_queue_processes parameter=100

The 11 oracle jobs run every second to check the next_run_date of a report specified in a table to see if it is time to call the work_summary package to run that report (which summaries data in one table and inserts the result into another).
After the work_summary package completes running the report, it updates the last_run_time and next_run_time fields in that table for that report.

The last_run_date of the reports in that table is the 18th. So I know the reports are not being run by the jobs.

I can the reports using that package manually which is fine but even then the last_run_time and next_run_time fields are not updated!

so that we can assume that there is something wrong with the package.

Is it the new job created or running well some time before? Compile the package once and see if it shows any errors like any missing dependencies.

Thanks,