When modules are retired without inactivating the campaign inside of the related questionnaire, then the campaign will still continue to execute but will never process any data due to the status of the modules.
Repeat steps 5-6 for each campaign in this questionnaire
Repeat steps 1-7 for all Retired and Archived Questionnaires.
Identify campaigns that are wasting server resources with the below SQL query.
--Find Active Campaigns tied to Retired/Archived questionnaires that target Development/Production applications.
select mt.module_name as Questionnaire, mt.module_id as 'Questionnaire module_id', c.campaign_name, c.campaign_id, mt2.module_name as 'Target', mt2.module_id as 'Target module_id' from tblCampaign c with(nolock)
JOIN tblModuleTranslation mt with(nolock) on mt.module_id = c.module_id
JOIN tblModule m with(nolock) on m.module_id = mt.module_id
JOIN tblLevel l with(nolock) on l.level_id = m.target_level_id
JOIN tblModuleTranslation mt2 with(nolock) on mt2.module_id = l.module_id
JOIN tblModule m2 with(nolock) on m2.module_id = mt2.module_id
where c.campaign_type_id = '2' and c.is_active = '1' and m.status_id in ('2','3') and m2.status_id in ('0','1')
Edit the Retired/Archived Questionnaire and inactivate the campaign that was returned by the above query.
Data feeds and questionnaires associated with the retired questionnaire continue to use system resources. Prior to retiring a questionnaire, RSA recommends the following:
Deactivate all data feeds that target retired questionnaire
Deactivate all campaigns within the questionnaire
For more information, please see the Archer Help topic "Changing the Questionnaire Status"