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

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
- #14528 Use DBA or USER prefix for the scheduler job log viewing — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
- #14528 Use DBA or USER prefix for the scheduler job log viewing (#15713) — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
Thank you Anastasiya for this investigation. I made new issue https://github.com/dbeaver/dbeaver/issues/17909
Have a nice day.
bye