Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER time-out

edited Nov 19, 2017 4:02AM in Database Administration (MOSC) 2 commentsAnswered

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);

Tagged:

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