A while back it was suggested that I delete the journals in order to speed things up/make more space. I have searched and can't seem to find any information on how to do this. Do I need to run an sql or is there simply something ro run on RMS?
Thanks for the help.
coupleofdogs
Actually, journals cosume a big amount of space in the database, u can schedule a job to delete journals older than 1 or 2 moths (based on what the finance department will accept)
just create a new job, schedule it to run on daily basis to remove journals older than a month, add the following statement in the only step in the job
************************* DELETE Journal WHERE Time < getdate() - 30 *************************
What about a simple way to archive them without an add-in? Any possibilities?
How are they stored in the database?
Have something to add? Share your thoughts — no account required.
Ask the community — no account required