External Job Hang In "JS External Job" Wait Event
(Doc ID 1669534.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Scheduler session is hanging in "JS external job" wait event.
exec DBMS_SCHEDULER.CREATE_CREDENTIAL('ORACLE_CRED','oracle','****');
begin
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'gzip_job',
job_type => 'EXECUTABLE',
job_action => '/bin/gzip',
number_of_arguments => 1,
enabled => false,
auto_drop => true,
credential_name => 'ORACLE_CRED');
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('gzip_job',1,'/tmp/test.txt');
DBMS_SCHEDULER.ENABLE('gzip_job');
end;
/
begin
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'gzip_job',
job_type => 'EXECUTABLE',
job_action => '/bin/gzip',
number_of_arguments => 1,
enabled => false,
auto_drop => true,
credential_name => 'ORACLE_CRED');
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('gzip_job',1,'/tmp/test.txt');
DBMS_SCHEDULER.ENABLE('gzip_job');
end;
/
Prompt returned but an ACTIVE session hang in "JS external job" wait event.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |