The RSA Archer Job Engine has a large number of "RecurringCampaign" jobs and it is not clear which campaigns these jobs are associated with.
Identify the campaigns associated with the 1000 most recently queued Recurring Campaign jobs. Run attached "Get_recurring_campaign_job_Details.sql"
(Optional) Review the questionnaire returned by the query (1) above and from the application builder of the questionnaire, note the target application of the questionnaire. If there are any automated processes that are updating large numbers of content records in the target application of the questionnaire, these content updates will create a new RecurringCampaign job for each content record updated. Based on the quantity of jobs created, evaluate whether a recurring campaign is optimal for this questionnaire and target application combination.