Synchronise all Scheduled Searches to a specific PaFid - ACS - Reference Guides

ACS Installation and Administration Guide

Product
ACS
AFS_Version
7.11
Category
Reference Guides
language
English
audience
public
  1. Connect to the CKS mysql database:

    mysql -uroot -p'root_password'

  2. Select CKS database

    use CKS_<service_id>_${Service_Status}; # use CKS_10041_stable for instance

  3. Perform the update (SQL query works only for CKS 7.4 and 7.5):

    update search_paf_ids set paf_id = <paf_id> where search_id IN (select search.id from search, schedule where search.schedule_id = schedule.id and schedule.schedule_type = '<schedule_type>');

    paf_id : integer - lenght 11
    schedule_type : char - lenght 1
    -> D for daily
    -> W for weekly
    -> M for monthly
    -> Run command once for each type above

  4. Re-schedule all the scheduled searches. See appendix Re-Schedule all Scheduled Searches.