scheduled job runs at wrong time
Hi Everyone,
We have a weekly scheduled stats job to start every sat at 8 am. It run successfully.
CLMPROD STATS WEEKLY STATS_MAIN_TBLS_send_mail
STARTED: 09/26/09 08:00:01
ALL OBJECTS STATS CALCULATED 09/26/09 22:02:23
But for some reason, it starts itself again and get an error several days later (before next_date):
CLMPROD STATS WEEKLY STATS_MAIN_TBLS_send_mail
STARTED: 09/30/09 08:59:49
Beginning of Process 09/30/09 09:07:12ORA-01157: cannot identify/lock data file 1002 - see DBWR trace file
ORA-01110: data file 1002: '/u13/oradata/clmprod/TS_TEMP_01.dbf'
The failures column of dba_jobs for this job shows nothing. No Ora- error is seen in alert log or trace files in bdump and udump.
We have a weekly scheduled stats job to start every sat at 8 am. It run successfully.
CLMPROD STATS WEEKLY STATS_MAIN_TBLS_send_mail
STARTED: 09/26/09 08:00:01
ALL OBJECTS STATS CALCULATED 09/26/09 22:02:23
But for some reason, it starts itself again and get an error several days later (before next_date):
CLMPROD STATS WEEKLY STATS_MAIN_TBLS_send_mail
STARTED: 09/30/09 08:59:49
Beginning of Process 09/30/09 09:07:12ORA-01157: cannot identify/lock data file 1002 - see DBWR trace file
ORA-01110: data file 1002: '/u13/oradata/clmprod/TS_TEMP_01.dbf'
The failures column of dba_jobs for this job shows nothing. No Ora- error is seen in alert log or trace files in bdump and udump.
0