Allow users to perform a Job only after hours

Question

I am trying to understand or come up with a solution for the issue we currently having in our Org. We have a situation that our Marketing users are adding the existing contacts to the Campaign which like 35K records are getting added to a campaign which locks the records for few mins that other users cannot add those contacts to the Cases that they are creating, which basically creates deadlocks on the records.

The users are using the reports and adding the Contacts from the report to Add to Campaign button on the report which is causing the issue

Is there a way to restrict the users to run these only after hours or have a way so that they can schedule this contacts to be added to Camapign after hours like in the night.

Implement the schedulable interface (https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_scheduler.htm) but I am not sure if this is the way to go.Any suggestion or help is greatly appreciated.

Answer 1

This is a kind of transaction security policy where user is restricted to do certain things based on the action they perform on the org

This type of situation is very well handled by TransactionSecurity policies Have read this salesforce developer guide, it has detailed information and explanation to implement.

For your use case, you will have to implement a policy for a campaign member object

pseudo code picked from the guide link posted above

global class BlockAccountQueriesEventCondition implements TxnSecurity.EventCondition {

   public boolean evaluate(SObject event) {
      switch on event {
         when ApiEvent apiEvent {
            return handleApiEvent(apiEvent);
         }
         when null {
         // Trigger action if event is null
            return true;
         }
         when else {
         // Trigger action for unhandled events
            return true;
         }
      }
   }

   private boolean handleApiEvent(ApiEvent apiEvent){
      if(apiEvent.QueriedEntities.contains('Account')){ 
         return true;
      } 
      return false;
   }
}