Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER job status marked as FAILED even though the script ran fine

Any help is much appreciated. Have tried and verified all the possible ways

19.15 version, New jobs or the existing jobs of type EXECUTABLE[Runs simple linux scripts] which runs fine and generates the file as expected but its marking the status as FAILED

SQL> select log_id,log_date,job_name,status,error#,additional_info from dba_scheduler_job_run_details where job_name='SEN_TE1';

LOG_ID LOG_DATE

JOB_NAME

STATUS ERROR#

ADDITIONAL_INFO

478822 07-MAY-25 04.43.03.705768 PM +00:00

SEN_TE1
FAILED 10
ORA-27369: job of type EXECUTABLE failed with exit code: 10 Could not get exit status of job, errno is 10

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