Hi All, I am using Release 18.104.22.168.0 of oracle. We migrated all of our jobs to scheduler recently.
and i just found that our job has been running in different times. All the database scheduled job are running 5hr(Perhaps EST) gap and application jobs are showing to be executed ~8hrs(perhaps PST) of gap.
So i verified that my DBA_SCHEDULER_GLOBAL_ATTRIBUTE shows EST5EDT and my expectation was GMT. Now below are my issues
1.The JOBS from application side those submitted to scheduler , should also show the same EST5EDT time on ACTUAL_START_DATE, but these are showing PST time.
2.Again even if i set this time to GMT in my local. And rerun the job(from database schedule but not application), it shows same EST5EDT time on ACTUAL_START_DATE column of dba_scheduler_job_run_details.
attribute => 'default_timezone',
value => 'GMT');
Job time zone is derived from job start_date. Only when this attribute is NULL then Scheduler setting is used.
See this for more details:
and there is documentation http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72235
look for "time zone"