DBMS Scheduler - use of timestamps with TZ

[S. Studeny]

Hi.

In PLSQL's DBMS scheduler management iface, there is no TIMESTAMP WITH TIMEZONE option to add timezone in start_date/end_date job property like '22.11.2019 08:00:25,000000 EUROPE/PRAGUE'

I would prefetch info from following dynamic performance view to allow user to select correct TZ with correct DST settings.

select * From V$TIMEZONE_NAMES

Regards,
Stanislav

 

[S. Studeny]

Please ignore, now i spotted option to allow to use timestamp format for DBMS scheduler objects :-]

 

[S. Studeny]

But, it will be more user-friendly to add some datepicker component with timestamp with tz support. Also hint will be good with info, what are current session nls timestamp format settings, so one would not hit ORA-01843: not a valid month or similar when creating job.