Forum Discussion

Andrew_Tankersl's avatar
Andrew_Tankersl
Level 6
19 years ago

CA Scheduled Searches

Does anyone know of a way to stop all currently running searches in bulk for Compliance Accelerator It looks as if all of my shceduled searches are running three times each. I'd like to stop all o...
Compliance Accelerator
Information Governance
  • Lone-Wolf's avatar
    Lone-Wolf
    19 years ago
    Stop CA Service

    Run this script in Query Analyzer:

    -- Sets all vaults to be finished.

    Update tblsearchvault set statusid = 13 where statusid in (11,12,15,16)
Lone-Wolf's avatar
Lone-Wolf
Level 3
19 years ago
Stop CA Service

Run this script in Query Analyzer:

-- Sets all vaults to be finished.

Update tblsearchvault set statusid = 13 where statusid in (11,12,15,16)