USoft
Production has an application timer that allows scheduled
constraint execution. The timer consists of an application table
T_APP_TIME, and an executable USCLOCK.EXE that updates T_APP_TIME
with the current database time at regular intervals.
The application timer
(USCLOCK.EXE) can be run continuously against the USoft
Developer-built application. The timer keeps the T_APP_TIME table
synchronized with the database time by incrementing it at fixed
intervals. After each increment and the execution of the
constraints that are fired by the increment, the application timer
commits the transaction. The application timer rolls back the
transaction and stops if it encounters a violation as a result of
an increment.
|