-
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.
-
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"
-
Are there any error being displayed?
-
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
|