The system has millions of records with a next action date in the past. Most of the records appear to be (ASYNC: Handle User-Activation CT Tracking). This backup is causing a delay with our other jobs.

Similar to KB0789201/PRB1374288 except the name has an ending 'g'  '

ASYNC: Handle User-Activation CT Tracking <> ASYNC: Handle User-Activation CT Trackin

Madrid P7a

1. The high volume of ASYNC: Handle User-Activation CT Tracking jobs comes from the Business Rule Handle User-Activation CT Tracking which comes from this functionality: Using Subscription Management to Monitor Usage
2. The Business Rule Handle User-Activation CT Tracking activates when any update is made on the sys_user table
3. Imports that are making a lot of updates to the sys_user table will cause this issue.
4. This is related to PRB1374288 but with a slightly different symptom.

You can delete all of the pending ASYNC: Handle User-Activation CT Tracking jobs so it does not delay your other jobs from running

For preventive measure, you can do either of the following:

1. Disable business rules to run when running the imports to the sys_user table
   
   • OR
2. Add a condition on the business rule Handle User-Activation CT Tracking to not execute the update comes from an import (maybe by the user who is making the update to sys_user)
   
   • OR
3. Disable the business rule Handle User-Activation CT Tracking if you're not using it.