My Oracle Support Banner

Query Over DBMS_SCHEDULER Jobs Shows Time Values an Hour Late On 10.2.0.5.0 Database (Doc ID 2818162.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle SQL Developer - Version 20.2 and later
Information in this document applies to any platform.

Goal

DBMS_SCHEDULER jobs are shown running an hour late on 10.2.0.5.0 database when a query is made in SQL Developer, compared with the same query in SQL Plus.

It looks like it is starting at 01:05:00, but it should be starting at 00:05:00
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.