-
Notifications
You must be signed in to change notification settings - Fork 79
CheckReloadJob
BonnoSmeele edited this page Oct 15, 2024
·
1 revision
Can be used to clean up tables or other execute other DB management routines:
<Scheduler>
<ExecuteQueryJob name="DeleteOldRecordsInterestValues"
cronExpression="0 0 20 ? * * *"
query="DELETE FROM InterestValues WHERE StoreDate <= ADDDATE(NOW(), INTERVAL -1 DAY)"
description="Deletes old interestvalues and InterestValuesWOZ from Database every day at eight in the evening">
<locker
objectId="DeleteOldRecordsInterestValues"/>
</ExecuteQueryJob>
</Scheduler>