View Incident Report

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

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap