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

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

Parents
  • 0
    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
    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