DBMS_SCHEDULER time-out
Hi All!
We have one bad effect using DBMS_SCHEDULER package for executing OS commands on Oracle Server 12.1:
After executing an OS command in synchronous mode, there is a 2 seconds of idle waiting before the dbms_scheduler.run_job procedure ends.
Here is an example of code:
begin
DBMS_SCHEDULER.CREATE_JOB
(job_name=>'jjjjj',
job_type =>'EXECUTABLE',
job_action =>'/bin/rm',
number_of_arguments => 2,
enabled => false
);
dbms_scheduler.set_job_argument_value('jjjjj',1,'-f');
dbms_scheduler.set_job_argument_value('jjjjj',2,'/u00/app/oracle/tmp/rsa_9999.xlsx');
dbms_output.put_line (systimestamp);
dbms_scheduler.run_job('jjjjj',false);