Database Administration (MOSC)

MOSC Banner

Jobs submitted via SCHEDULER stopped working

edited Apr 15, 2013 12:22AM in Database Administration (MOSC) 7 commentsAnswered
Hi

We are using DBMS_SCHEDULER on our 10.2.0.4 database on HP Open VMS 8.3
All the jobs we created are EXECUTABLE in nature

The jobs have been running fine for over a year but all of a sudden they have stopped running
There is nothing wrong with the script (.com files) that is defined in the job and we can manually run the script and it runs fine.
We can also run the job manually using --> EXEC dbms_scheduler.run_job('ORA_TS_MONITOR');
and it runs fine


Here is one of the jobs that we had defined and that has stopped running

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