[SalesForce] Mass deletion of records through apex

Aim- I want to delete any record within custom object training__c where the created date is greater than 6 months from today's date.

I would like to run this job daily.

I apologise if the following below has errors I just wrote this on my iPhone, Does the following logic below make sense ?

Looking forward to your help

List listsObject = [Select Id from training where Createddate <= ( Current Date – 6 months) Limit 9000];Delete

Best Answer

You could create a class that implements the schedulable interface and do something like this:

global class ScheduledDelete Implements Schedulable {

    global void execute(SchedulableContext sc) {

        massDelete();

    }

    public void massDelete() {
        List <training__c> listtoDelete = [Select Id FROM training__c WHERE CreatedDate CreatedDate = LAST_N_DAYS:180];
        delete listtoDelete;
    }


}

Then, you can schedule the class to run daily from an anonymous block or by going to Setup > Develop > Apex Classes > Schedule Apex.

Related Solutions

[SalesForce] How to delete 10K records in Salesforce via Apex

Yes, it will work just fine. You can even write it in 1 line:

delete [Select Id from sObject where Test__c = true Limit 9000];

It will fail the whole delete operation though if there's any kind of problem (like "before delete" trigger that makes some extra checks and complains). You can set it to "delete what you can, I'll deal with errors separately" by using another version of delete that takes an extra parameter.

Database.delete([Select Id from sObject where Test__c = true Limit 9000], false);

[SalesForce] Mass Deletion Of (most) Records (in Sandbox) (100 million+)

Write a chained batchable class:

public class KillMostBatch implements Database.Batchable<SObject> {
    public Database.QueryLocator start(Database.BatchableContext context) {
        return Database.getQueryLocator([SELECT Id FROM MyObj__c LIMIT 20000000]);
    }
    public void execute(Database.BatchableContext context, MyObj__c[] scope) {
        if(scope.size()==200) {
            delete scope;
        }
    }
    public void finish(Database.BatchableContext context) {
        if([SELECT Count() FROM MyObj__c LIMIT 1]==1) {
            Database.executeBatch(this, 200);
        }
    }
}

This will leave at most 200 records. Yes, if it's an even multiple of 200, you'll be completely wiped out. This code will continue to eat all available records until less than 200 remain. Your recycle bin will be full, expect permanent loss.

Best Answer

Related Solutions

[SalesForce] How to delete 10K records in Salesforce via Apex

[SalesForce] Mass Deletion Of (most) Records (in Sandbox) (100 million+)

Related Topic