How to diagnose job execution failure
1. Check whether the job can be executed.
Make sure that the job_queue_processes parameter in init. ora is set to a value greater than 0.
Show parameter job_queue_processes
2. Check whether an error occurred while executing the job.
View alert. log for error information.
3. Check whether the procedure/package called by the job has an error.
This requires you to write your own Error Log Code in procedure/package.
4. Check your DBA_JOBS frequently to see if the corresponding job is broken,
BROKEN: Y: no attempt is made to run this job
N: an attempt is made to run this job
A job can be broken in two ways:
Oracle has failed to successfully execute the job after sixteen attempts. The job has been explicitly marked as broken by using the procedure DBMS _ JOB. BROKEN.
The job cannot be successfully executed after 16 attempts (default). The job is automatically marked as broken = y by oracle.
Or you can run it manually to see if there are any error messages.
EXECUTE DBMS_JOB.RUN (JOB_ID );