DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Dbms_scheduler Issue

  1. #1
    Join Date
    Aug 2004
    Location
    bangalore
    Posts
    10

    Dbms_scheduler Issue

    We have some jobs that were running properly (daily jobs). But from 15-Jul-2006 onwards these jobs are not running.
    Please any body can tell what may be the reason and what is the solution now. Shall I recreate all jobs?

    Some query results are as follows:
    SQL> select JOB_NAME,ENABLED,NEXT_RUN_DATE from all_scheduler_jobs where OWNER='SAC';

    JOB_NAME ENABL NEXT_RUN_DATE
    ------------------------------ ----- -----------------------------------
    CMP_ASSMNT_SCHEDULER_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_GO_LIVE_CHG_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_NOT_SCHEDULED_YET_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_OLM_STATUS_CHANGE_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_CHK_DATA_MISSING_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_GO_LIVE_CHG_GT30_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_CHECK_NPR_ALERT_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_MAILER_JOB TRUE 15-SEP-06 07.30.00.000000 PM -07:00
    CMP_CRON_CHECK_CRP_ALERT_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00
    CMP_CRON_CHECK_READY_AI_JOB TRUE 15-SEP-06 07.00.00.000000 PM -07:00

    10 rows selected.

    sql>select JOB_NAME,ACTUAL_START_DATE,STATUS from ALL_SCHEDULER_JOB_RUN_DETAILS where owner='SAC' order by 2;

    JOB_NAME ACTUAL_START_DATE
    ------------------------------ -----------------------------------
    STATUS
    ------------------------------
    CMP_CRON_CHK_DATA_MISSING_JOB 14-SEP-06 07.00.33.381398 PM -07:00
    SUCCEEDED

    CMP_CRON_GO_LIVE_CHG_GT30_JOB 14-SEP-06 07.00.37.830912 PM -07:00
    SUCCEEDED

    CMP_CRON_CHECK_NPR_ALERT_JOB 14-SEP-06 07.00.38.781307 PM -07:00
    SUCCEEDED
    CMP_CRON_CHECK_CRP_ALERT_JOB 14-SEP-06 07.00.43.370231 PM -07:00
    SUCCEEDED

    CMP_CRON_CHECK_READY_AI_JOB 14-SEP-06 07.00.43.780900 PM -07:00
    SUCCEEDED

    CMP_MAILER_JOB 14-SEP-06 07.30.00.255639 PM -07:00
    SUCCEEDED




    I have give last few rows. Other are similar to that.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Question

    Quote Originally Posted by ahmad_anees
    Please any body can tell what may be the reason and what is the solution now. Shall I recreate all jobs?
    Before recreating the jobs won't you analyze why? what made it to stop?
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Feb 2003
    Posts
    63
    Are there any error being displayed?

  4. #4
    Join Date
    Aug 2004
    Location
    bangalore
    Posts
    10
    No error.

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