Who Me Too'd this topic

Showing results for 
Show  only  | Search instead for 
Did you mean: 

Who Me Too'd this topic

Former Member
Not applicable
Report Inappropriate Content

Truncate OrionSchedulerTaskLog/OrionSchedulerTaskLogDetail tables through SQL?

Under EPO 4.5, Both OrionSchedulerTaskLog and OrionSchedulerTaskLogDetail are huge tables in SQL.


rows        reserved       data    index_size    unused


2519079        942112 KB    329200 KB    611808 KB    1104 KB


10900682    2263920 KB    1849936 KB    413760 KB    224 KB

Deleting by date does work, but due to the amount of data involved is a very difficult and time consuming task. Plenty of timeouts etc.

Would there be negative consequences (apart from not being able to view Scheduled Task Logs) from doing the following:

use epo_<Servername>

Truncate table OrionSchedulerTaskLog   

Truncate table OrionSchedulerTaskLogDetail

Message was edited by: mjmurra on 13/03/12 5:53:42 PM
Who Me Too'd this topic

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community