Database Administration (MOSC)

MOSC Banner

scheduled job runs at wrong time

edited Oct 9, 2009 10:17AM in Database Administration (MOSC) 6 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center