Database logging monthly

[VKP]

Hi , We use access database for logging & result data goes to single file which gets appended. Is there an option to do logging month wise ? Can someone suggest how to achieve month wise database logging. Thanks VKP 

[~jiggawax~]

Do you not want to store the results from every execution?  Or are you talking about archiving your database once a month because you are using Access and so the file size gets too large?

[VKP]

Hi Jigg

We would like to archive every month , Is there an option in Schema to handle this automatically? If not can you suggest some option or what changes can be done in code. At the moment access database gets updated for every execution & there is no monthly archive facility so file gets big unless we archive it manually.

[~jiggawax~]

I'm not sure of anything built into TestStand for doing this.  There are several things you could do but here would be my suggestion.  Create a windows scheduled task to fire every month and copy your database to an archived location.  You would need to use a batch file or something.  I'm not the best with scheduled tasks but here is some info on them:

https://www.technipages.com/scheduled-task-windows

You can google scheduled tasks and find some more info on them: http://bfy.tw/KlPT

The other option would be to do it every time the user kicks off an execution or ends an execution and just check the last timestamp for the access file.  If it is past a month then archive it and create a new empty one.

Hope this helps,