Scheduled Job Of Type EXTERNAL_SCRIPT Fails With ORA-27369 On Windows (Doc ID 2065024.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Oracle Job of type EXTERNAL_SCRIPT is failing with ORA-27369

Manual execution of .cmd works with no errors

Example:

BEGIN
dbms_scheduler.create_job(
job_name =>'testjob',
job_type =>'EXTERNAL_SCRIPT',
job_action =>'D:\test_admin\test_Jobs\test.cmd' ,
job_class =>'DEFAULT_JOB_CLASS',
credential_name =>'CRED_test',
comments =>'test job');
dbms_scheduler.enable( 'testjob' );
dbms_output.put_line(dbms_utility.format_error_stack);
dbms_output.put_line(dbms_utility.format_error_backtrace);
dbms_output.put_line(dbms_utility.format_call_stack);
EXCEPTION
WHEN OTHERS THEN
Raise;
END;

ORA-27369: job of type EXECUTABLE failed with exit code




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms