Oracle jobs not picking the job up....9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 12

Thread: Oracle jobs not picking the job up....9i

Hybrid View

  1. #1
    Join Date
    Dec 2007
    Posts
    9

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    check dba_jobs and the alert log

  3. #3
    Join Date
    Dec 2007
    Posts
    9
    Thanks.

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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    look at the last run and next run dates

  5. #5
    Join Date
    Dec 2007
    Posts
    9
    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?

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    look into the "what" column in dba_jobs and check what the underlying procedure / package is doing.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  7. #7
    Join Date
    Dec 2007
    Posts
    9
    That's what I can't understand. Why the job cannot call the package, it is supposed to call!!!!!!!!!!!!!

  8. #8
    Join Date
    Dec 2007
    Posts
    9

    Angry

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

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

  9. #9
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ...and, if you still don't trust what you see make underlying package/procedure to write a detailed log.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width