Scheduler Job class create script does not include: "logging_level => SYS.DBMS_SCHEDULER.LOGGING_FAILED_RUNS"

Toad for Oracle & DevOps Toolkit
1

14.0.75.662 (same in 13.3 also as I recall)
14.1.42.811

Scheduler Job class create script does not include:

logging_level => SYS.DBMS_SCHEDULER.LOGGING_FAILED_RUNS

image
image819×540 27.9 KB

For example, these others, are fine.

  • DBMS_SCHEDULER.LOGGING_OFF
  • DBMS_SCHEDULER.LOGGING_RUNS
  • DBMS_SCHEDULER.LOGGING_FULL

image

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB_CLASS
    (
      job_class_name          => 'DEFAULT_JOB_CLASS_FAILED_RUNS'
     ,resource_consumer_group => NULL
     ,service                 => NULL
     ,logging_level           => SYS.DBMS_SCHEDULER.LOGGING_FAILED_RUNS
     ,log_history             => NULL
     ,comments                => 'This is the job default class, where logging only errors.'
    );
END;
/

Raul

2

Thanks Raul.

I'll fix it.

-John

1 Like