Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 3/7/2022
For: Version 2.36 Build 1
# 4907 Monthly Jobs Scheduled for a Specific Day of Week Not Executing Properly

EDB 2.36b1. It appears that Monthy scheduled jobs based upon the day of the week setting increment by a week instead of by a month. So, the job created with the DDL below ran on the 7th (2022-03-07), and then after the execution window closed out, it set the next run date for 2022-03-14.

Monthy based upon the day number increment correctly.

CREATE JOB "Test" 
RUN AS "Administrator" 
FROM DATE '2022-03-07' TO DATE '2099-03-07' 
MONTHLY ON FIRST MON OF JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC 
BETWEEN TIME '16:50' AND TIME '16:50:30.999' 
BEGIN 
END 



Comments Comments
There were two issues: both the scheduling of the job execution and the next-run calculations were not working properly for day-of-week, monthly jobs.


Resolution Resolution
Fixed Problem on 2/1/2023 in version 2.37 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image