• State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 2614 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Process History cleanup

ellen
over 7 years ago

We have a development database with no history database and a very large process history (over 14 million now!).  I've adjusted the config so it only saves the last 2 weeks of data, but we have lots of data going through and are making lots of changes, so that didn't seem to make much difference.  Does anyone know the proper way to manually clean up the process history?

 

Thanks!

 

Ellen

  • 0 over 7 years ago

    JobHistory is a heap and unfortunately heaps do not get re-organized during daily maintenance (which is an oversight in my opinion).

    What I do is i clean it up manually from time to time:

    ALTER TABLE JobHistory REBUILD

    That should free up DB space after entries have been deleted.

    As always, be careful with such DB-level actions. There is also some philosophical debate on how to do this propery, but I found this to be the most simple way.