What is the use case for the SQL Jobs installed with DCS 6.10

Products

• Data Center Security Server Advanced

Issue/Introduction

What is the use case for the following SQL Jobs

• Symantec_DefragBaseTablesJob
• Symantec_DefragEventTablesJob
• Symantec_KillBlockingProcessJob

Environment

DCS 6.10.x

Resolution

These jobs provide database maintenance for DCS 6.10.x

• Defragmentation Jobs: Run weekly or monthly outside business hours to address fragmentation levels exceeding 30%.
  • Symantec_DefragBaseTablesJob
  • Symantec_DefragEventTablesJob
    
    
• Kill Blocking Process Job: Utilized by the DCS Management Service as required.
  • Symantec_KillBlockingProcessJob