To clean up the database I often use the recommended procedure from the command line osql –E
I delete all records older than 1 month.
Is it possible to run a script to calculate the date and run a scheduled job for the following actions?
1> use issed
2> exec iss_purgeevents ‘1/1/2003 00:00:00’,’4/31/2003 00:00:00’,100
I like to run this job daily during the night. It has to purge records older than 31 days.
I could not find something, which looks like this in the knowledgebase.
Rick van Wijnen.