CA Scheduled Searches

[Andrew_Tankersl]

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 of them at once.
Thanks-

[Lone-Wolf]

what ver?

[Andrew_Tankersl]

5 SP3

[Lone-Wolf · Accepted solution]

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)

[Andrew_Tankersl]

Thanks red - I'll give that a try...