DBMS Scheduler requires enhancements

Maxmix

Member³
1. Viewing some Schedule, I press View SQL and get 'Could not convert variant of type (String) into type (Double)'. AND THE SAME ERROR WITH APPLY BUTTON - IMPOSSIBLE TO CREATE SCHEDULE.

2. Could you display both job owner and job creator(column DBA_SCHEDULER_JOBS.JOB_CREATOR).
Because execution of job depends heavily on this value.

3. Viewing some Job, on tabs Run details, Log there is an column Additional Info, but it presents its data in an inconvenient way: one cannot see the text unless it is short and takes only one line (exceptions often span multiple lines). I would like to be able
to see the text in a separate window
OR to change row's height
OR at least, to popup a tooltip
OR something else...

4. I realize that not all would approve, but I would like to see all this ugly TIMESTAMP(6) WITH TIME ZONE values (all the info in job itself and its logs pertaining to "time") in the "normal" format (31.12.2015 23:59:59). The government constantly shuffles time zones and it's difficult to ascertain at which real moment something happened or will happen. Another complain is: timestamps are too long and occupy precious space. Could you convert these values to_date for me and allow to choose which data to see: timestamps or dates?
 
Last edited:
Okay. We'll look into issue 1. I have added 2 and 3 to the list of enhancement requests. For 4 you can disable the "User timestamp format for scheduler objects" option (Tools > Preferences > Oracle / Options). When disabled they will be displayed as normal dates & times.
 
you can disable the "User timestamp format for scheduler objects" option

It's a miracle! PLSD seems to have all options that one needs or will need in the future.
Thank you, Marco!
 
Back
Top