• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 95 subscribers
  • Views 4728 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
    Do you want to preserve the history or not? that's the question here.. if you're not interested you can unconfigure the property model so you're not storing this and don't end up with 50 million records again, then truncate the table to avoid huge rollback transactions and losing temp space.
Reply
  • 0 over 8 years ago
    Do you want to preserve the history or not? that's the question here.. if you're not interested you can unconfigure the property model so you're not storing this and don't end up with 50 million records again, then truncate the table to avoid huge rollback transactions and losing temp space.
Children
No Data