Oracle Job Execution failed

To create a job task:
Declare
Test_job number;
Begin
Dbms_job.submit (Test_job, ' prc_job_test; ', Sysdate, ' sysdate+1/(24*60) ');--Perform a refresh once per minute
End

To view a user's job task:
SELECT * from User_jobs;

To perform a task, the parameter is the ID of user_jobs:
Begin
Dbms_job.run (65);
End

If an error occurs during execution, but the cause of the error is not explicitly stated, then we need to look at the execution log of the Oracle job:

SELECT * FROM V$diag_info

Find the log, open

The reason for the failure is here, change the length of the job re-execution, other errors can be the appropriate method of ending

Oracle Job Execution failed