[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ISSForum] SQL database maintenance for RealSecure WGM6.7



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.