Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 5/11/2008
For: Version 1.09 Build 3
# 2630 CREATE JOB Fails with Compilation Error for MONTHLY Jobs

When I try to create the following job, I always get the error:

ElevateDB Error #700 An error was found in the statement at line 5 and column 69 (Invalid expression DEC found, duplicate month specified)



CREATE JOB "Job5"
RUN AS "System"
FROM DATE '2008-05-11' TO DATE '2009-05-11'
MONTHLY
ON DAY 11 OF JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC
BETWEEN TIME '16:40' AND TIME '16:50'
CATEGORY ''
BEGIN
use "TestJobs";
execute immediate 'insert into JobExec(ExecTime) values(CURRENT_TIMESTAMP)';
END



Resolution Resolution
Fixed Problem on 5/13/2008 in version 1.09 build 4


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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image