Map Log Maintenance
Can I delete the records of old runs from TraceHeader and TraceLine? is it risky? or there are other method to do this?
I would like to know as well. I would be happy to schedule a SQL job to delete records older than X days, but I don’t want to break anything by missing a step or table. I suppose I could run a SQL Profile and get a list of affected tables. Does eOne have a configurable maintenance plan?
Possible functionality of Log Maintenance:
SmartConnect>[MapID]>Options>Use Log>Log Maintenance (button)
Log Maintenance Window:
Delete Trace Logs Older Than ____ Days
Reset Run Counter (checkbox)
– The “Enable” checkbox will allow the owner to decide to keep all log history or to periodically clean it up
– If enabled, the owner can select how long to keep trace logs
– The owner can elect to keep the original tally of map runs or reset it to match the current number of logs
– I can see how this would be a little more of a pain because we’d probably want the RunNumber in the Map table to
correspond with the RunNumber in the TraceHeader table, not that they match now if anything has ever been manually
Anyway, this seems like something that could be beneficial to have – but then again, I’m only seeing it from a couple of perspectives.
This is different than Log Maintenance in SmartConnect Setup
If you would like to submit an answer or comment, please sign in to the eOne portal.