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.

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

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

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

JohnGS Advanced User Asked on March 15, 2021 in Diyotta Studio.
Add Comment
1 Answers

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.

Expert Answered on March 18, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.