000037368 - How to identify the origin of large numbers of RSA Archer Recurring Campaign jobs

Document created by RSA Customer Support Employee on Apr 25, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037368
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition:
Platform: Windows
IssueThe RSA Archer Job Engine has a large number of "RecurringCampaign" jobs and it is not clear which campaigns these jobs are associated with.
  1. Identify the campaigns associated with the 1000 most recently queued Recurring Campaign jobs.
    Run attached "Get_recurring_campaign_job_Details.sql"   
  2. (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.