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

This question might be more towards the approach than the technical side. The scenario is the following:

I have to run a scheduler to delete some records. The record size is always going to be less than 10,000.

Can I retrieve all the results in a list like:

List <sObject> listsObject = [Select Id from sObject where Test__c = true Limit 9000];
Delete listsObject;

Will this be able to delete all the records in the list?! Or will this only delete the 200 records?

Also, I know I could follow the batch Apex Approach but I want to know first if this will work, and if this certainly works I dont have to write Batch Apex and then schedule it.

Best Answer

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);

Related Solutions

[SalesForce] How to re schedule a batch if already 5 apex batch jobs are running

I use this pattern, i've seen lots of others but all do something similar:

private static Integer getCurrentJobCount()
{
    return (Integer)[Select count() From AsyncApexJob Where JobType = 'BatchApex' and ( Status = 'Processing' or Status = 'Preparing' )];
}

private void submitJob( IReschedulable job, SchedulableContext SC )
{
    if( getCurrentJobCount() > 4 )
    {
        // try again in 15 minutes
        Datetime sysTime = System.now().addSeconds( 900 );

        String chronExpression = '' + sysTime.second() + ' ' + sysTime.minute() + ' ' + sysTime.hour() + ' ' + sysTime.day() + ' ' + sysTime.month() + ' ? ' + sysTime.year();

        System.schedule( job.getJobName() + sysTime, chronExpression, (System.Schedulable)job );
    }
    else
    {
        Database.executeBatch( (Database.Batchable<Object>)job, job.getBatchSize() );

        // abort scheduled job if this was as a result of a reschedule
        if( SC != null && job.getAbortAfterSubmit() )
        {
            System.abortJob( SC.getTriggerId() );
        }
    }
}

I've missed off some particulars, but hopefully you get the gist. You should basically put the count just prior to calling Database.executeBatch, which I'm guessing is in the BatchHandler class. I'm afraid it's not completely infallible, because there is of course a moment between the query returning < 4 and the job actually starting (at which point another job could have gotten in) but I've found it to be very reliable (and have it deployed in many orgs).

PS. Just noticed you're using System.scheduleBatch, I personally wouldn't trust that to be safe, see this post.

[SalesForce] is it possible to call a single batch job from multiple schedule apex

Direct answer: No, that won't cause you any problems. The execution context will be different each time the batch job is fired.

Something else to keep in mind: You don't need to define your batch job or its methods as global. This was the case when batch jobs first came on the scene, but not anymore. I'd recommend defining them as public instead. (No need to use global if you don't have to!)

Also, ctc_types and cpgn_types don't need to be defined as global. You can set them to private, since they're only being used by methods inside the test_batch_job class. Again, always better to encapsulate when you can.

Best Answer

Related Solutions

[SalesForce] How to re schedule a batch if already 5 apex batch jobs are running

[SalesForce] is it possible to call a single batch job from multiple schedule apex

Related Topic