• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 4729 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

JobHistory Table has around 50 million rows,How can we delete this if dont have a HistoryDB option

Pradeep Pola
over 8 years ago

 JobHistory Table has around 50 million rows,How can we delete this if we dont have a HistoryDB option .

Parents
  • 0 over 8 years ago
    TRUNCATE TABLE usually does a pretty good job with removing stuff.

    But why not simply set config parameter Common\ProcessState\JobHistory\LifeTime to a reasonably value and deactivate Common\ProcessState\JobHistory\IsToExport? Or leave this active but set Common\ProcessState\ExportPolicy to NONE?
Reply
  • 0 over 8 years ago
    TRUNCATE TABLE usually does a pretty good job with removing stuff.

    But why not simply set config parameter Common\ProcessState\JobHistory\LifeTime to a reasonably value and deactivate Common\ProcessState\JobHistory\IsToExport? Or leave this active but set Common\ProcessState\ExportPolicy to NONE?
Children
No Data