Issue

Even though tasks are executed using DBMS_SCHEDULER, no related log records are created.

Cause

The attribute of DBMS_SCHEDULER is set to nologging by default, so no logs are recorded when related tasks are executed.

To change the log level of DBMS_SCHEDULER, set the logging_level attribute to DBMS_SCHEDULER.LOGGING_RUNS as shown below.

begin
DBMS_SCHEDULER.SET_ATTRIBUTE(
NAME => 'INSERT_JOB',
ATTRIBUTE => 'logging_level',
VALUE => DBMS_SCHEDULER.LOGGING_RUNS
);
end;
/

Verification Query

--select job_name, LOGGING_LEVEL from dba_scheduler_jobs;

If the attribute value change is not applied correctly, the following patches related to DBMS_SCHEDULER must be applied.

Caution
Apply patches through technical support provided by Tmax Tibero.

Related to