Oracle Database Discussions

Hi

Oracle 12.1.0.2.0 (and also present in 11.2.0.4.0)

I created a scheduler job, with value:

LOGGING_LEVEL: SYS.DBMS_SCHEDULER.LOGGING_OFF

But it still generates job log:

select * from dba_scheduler_job_run_details where owner= 'ETOIMIK' and job_name = 'TEST_REFRESH';

Job is created like this:

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'ETOIMIK.TEST_REFRESH'
      ,start_date      => TO_TIMESTAMP_TZ('07:30:00 Europe/Tallinn', 'HH24:MI:SS TZR')
      ,repeat_interval => 'FREQ=SECONDLY; INTERVAL=10;'
      ,end_date        => NULL
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'PLSQL_BLOCK'
      ,job_action      => 'begin dbms_mview.refresh(''LEIAMENETLUSEDMENETASUTUSED_TE'',''f''); end;'
      ,comments        => NULL
    );
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'RESTARTABLE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'LOGGING_LEVEL'
     ,value     => SYS.DBMS_SCHEDULER.LOGGING_OFF);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'MAX_FAILURES');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'MAX_RUNS');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'STOP_ON_WINDOW_CLOSE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'JOB_PRIORITY'
     ,value     => 3);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'SCHEDULE_LIMIT');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'ETOIMIK.TEST_REFRESH'
     ,attribute => 'AUTO_DROP'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.ENABLE
    (name                  => 'ETOIMIK.TEST_REFRESH');
END;
/

Regards

Raul