Skip to content
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 &lt;= 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>
Clone this wiki locally