RE: Jobs will start may be not at expected time. Seems like jobs are not moving after day light saving started and we cannot see jobs started
jobs will start may be not at expected time. Seems like jobs are not moving after day light saving started and we cannot see jobs started. Our all MFS jobs are Diyotta scheduler only (except IHDB and IHDB Summary). We cannot see anything started from Diyotta scheduler.
Hi John,
As per the attached details and snapshots. We could see the start time and end times are shifted 1 hour forward as the daylight savings is started from March 14th.
Due to this start time 00:05 shifted to 01:05 and end time 23:59 shifted to 00:59. The jobs which are scheduled will be TIMING OUT.
In Scheduler calendar, START TIME shouldn’t be greater than the END TIME. To rectify this calendar start and end dates.
can you please try to run the below metadata queries
QUERY
create table sch_cal_Bck_032021 as select * from sch_cal;
UPDATE sch_cal
SET startdt = startdt – interval ‘1 hour’, enddt = enddt – interval ‘1 hour’
commit;
Once the above metadata queries are run, The jobs which are already scheduled will pick the updated timings in the calendar from the next schedule onwards.