|
Hello, 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? osql –E 1> use issed 2> exec iss_purgeevents ‘1/1/2003 00:00:00’,’4/31/2003
00:00:00’,100 3> go 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. Kind regards, Rick van Wijnen. |
