Icon View Incident Report

Serious Serious
Reported By: Mark Culos [Blackberry Civil Works]
Reported On: 11/3/2013
For: Version 2.14 Build 3
# 3915 Expanded CREATE/ALTER JOB Day Specifications Being Reset Incorrectly During Configuration Load

While the CREATE JOB statement using EVERY X MINUTES ON MON is accepted, the job is created to run every day. Issuing the ALTER JOB statement does set configuration.Jobs.Days correctly, but as configuration.Jobs.CreateSQL does not container the ON MON portion, when the job next runs, it is back to executing daily.

CREATE JOB "Test2"
RUN AS ""
FROM DATE '2013-11-03' TO DATE '2099-11-03'
EVERY 1 MINUTES
ON MON
BETWEEN TIME '06:38:12.362' AND TIME '20:38:12.362'
CATEGORY ''
BEGIN
END
VERSION 1.00



Comments Comments
These new day specifications (ON clause) were added in 2.12, so the bug has been present since then. The problem was with some reset logic in the configuration loading code that was supposed to be used to initialize the days for older configurations that didn't specify the days on which to execute the job.


Resolution Resolution
Fixed Problem on 11/5/2013 in version 2.14 build 5


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