Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.01 » View Incident Report |
Serious |
Reported By: Ulrich Doewich Reported On: 8/6/2008 For: Version 2.01 Build 4 |
if Config.Gen_PrimaryServer then begin SQL.Text := 'SELECT * FROM Jobs WHERE Name=' + EDBEngine1.QuotedSQLStr('Maintenance'); Open; // check if the job already exists if RecordCount = 0 then begin Close; SQL.Clear; SQL.Add('CREATE JOB Maintenance'); SQL.Add('RUN AS "System"'); SQL.Add('FROM DATE ''2008-01-05'' TO DATE ''2108-01-06'''); SQL.Add('HOURLY'); SQL.Add('BETWEEN TIME ''01:00 AM'' AND TIME ''11:59 PM'''); SQL.Add('BEGIN'); SQL.Add(' USE RCS;'); SQL.Add(' CALL ProcPurgeLog;'); SQL.Add(' CALL ProcGenerateUpdates;'); SQL.Add(' USE;'); SQL.Add('END'); {$IF Defined(DEBUG)} AddToLog('creating "Maintenance" job'); {$IFEND} ExecSQL; {$IF Defined(DEBUG)} AddToLog(' success'); {$IFEND} end else begin {$IF Defined(DEBUG)} AddToLog('"Maintenance" job already exists'); {$IFEND} Close; end; end else begin SQL.Text := 'SELECT * FROM Jobs WHERE Name=' + EDBEngine1.QuotedSQLStr('Maintenance'); Open; // check if the job already exists if RecordCount = 0 then begin Close; SQL.Clear; SQL.Add('CREATE JOB Maintenance'); SQL.Add('RUN AS "System"'); SQL.Add('FROM DATE ''2008-01-05'' TO DATE ''2108-01-06'''); SQL.Add('HOURLY'); SQL.Add('BETWEEN TIME ''01:05 AM'' AND TIME ''11:59 PM'''); SQL.Add('BEGIN'); SQL.Add(' USE RCS;'); SQL.Add(' CALL ProcGetUpdates;'); SQL.Add(' USE;'); SQL.Add('END'); {$IF Defined(DEBUG)} AddToLog('creating "Maintenance" job'); {$IFEND} ExecSQL; {$IF Defined(DEBUG)} AddToLog(' success'); {$IFEND} end else begin {$IF Defined(DEBUG)} AddToLog('"Maintenance" job already exists'); {$IFEND} Close; end; end;
This web page was last updated on Wednesday, October 30, 2024 at 11:41 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |