View Incident Report

Serious

Reported By: Fernando Dias
Reported On: 5/11/2008
For: Version 1.09 Build 3

# 2631 Altering an Existing Job and Only Modifying the Job SQL Causes the Changes to Be Ignored

ALTERing a "DAILY" job changing only the sql has no effect.

I created the following job, and then I tryed to change the SQL code using ALTER JOB. There was no error message generated, but the job remained unchanged. If I change something else (time or date) also, all works well, but if only the sql is changed, nothing happens.

CREATE JOB "Job3"
RUN AS "Administrator"
FROM DATE '2008-05-11' TO DATE '2008-05-11'
DAILY
BETWEEN TIME '16:55' AND TIME '16:59'
CATEGORY ''
BEGIN
  use "TestJobs";
  execute immediate 'insert into JobExec(ExecTime) values(CURRENT_TIMESTAMP)';
END

ALTER JOB "Job3"
RUN AS "Administrator"
FROM DATE '2008-05-11' TO DATE '2008-05-11'
DAILY
BETWEEN TIME '16:55' AND TIME '16:59'
CATEGORY ''
BEGIN
  use "TestJobs";
  execute immediate 'insert into JobExec(ExecTime) values(CURRENT_TIMESTAMP + 1)';
END

Resolution

Fixed Problem on 5/12/2008 in version 1.09 build 4

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap