dbeaver: Scheduler/jobs/Run Log is empty (oracle)

image

System information:

  • Operating system: OS: Ubuntu Budgie 20.04.3 LTS x86_64 (Kernel: 5.11.0-38-generic ) - but it’s same bug on windows 10
  • DBeaver version: 21.2.4.202111011413

Connection specification:

  • Database name and version: oracle 19c EE (but same bug on other versions of oracle)
  • Driver name: ojdbc7.jar

Describe the problem you’re observing:

Run Log for dbms_scheduler is empty for every job

Steps to reproduce, if exist:

begin    DBMS_SCHEDULER.CREATE_JOB (
            job_name => 'MY_JOB',
            job_type => 'PLSQL_BLOCK',
            job_action => 'BEGIN
						null;
                           END;',
            number_of_arguments => 0,
            start_date => TO_TIMESTAMP_TZ('2014-04-04 01:30:00.000000000 EUROPE/PRAGUE','YYYY-MM-DD HH24:MI:SS.FF TZR'),
            repeat_interval => 'Freq=DAILY;ByHour=5;ByMinute=45',
            end_date => NULL,
            enabled => FALSE,
            auto_drop => FALSE,
            comments => 'desc');
END;            

BEGIN DBMS_SCHEDULER.run_job('MY_JOB',false); END;

SELECT * FROM USER_SCHEDULER_JOB_RUN_DETAILS  WHERE job_name ='MY_JOB' --this IS NOT empty 

and than go to: Scheduler/jobs/MY_JOB/Run Log and ther will be label “no data” (on screenshot it’s diferent job, but it’s same result for all jobs)

About this issue

  • Original URL
  • State: closed
  • Created 3 years ago
  • Comments: 38 (16 by maintainers)

Commits related to this issue

Most upvoted comments

Thank you Anastasiya for this investigation. I made new issue https://github.com/dbeaver/dbeaver/issues/17909

Have a nice day.

bye