Lesson: 39 | Batch Apex | Inactive Account Deleter

Create a Batch Apex class that deletes all accounts that have been inactive for more than 3 months:

Send an email notification to the administrator.

Apex Class

public class InactiveAccountDeleter implements Database.Batchable<Account> {
    private final Integer INACTIVE_THRESHOLD_MONTHS = 3;

    public Iterable<Account> start(Database.BatchableContext context) {
        Date currentDate = Date.today();
        Date thresholdDate = currentDate.addMonths(-INACTIVE_THRESHOLD_MONTHS);
        return [SELECT Id FROM Account WHERE LastActivityDate < :thresholdDate];
    }

    public void execute(Database.BatchableContext context, List<Account> accounts) {
        Database.delete(accounts, false);
    }

    public void finish(Database.BatchableContext context) {
        // Send an email notification to the administrator
        Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();
        String[] toAddresses = new String[] {'admin@example.com'};
        email.setToAddresses(toAddresses);
        email.setSubject('Inactive accounts have been deleted');
        email.setPlainTextBody('All accounts inactive for more than ' + INACTIVE_THRESHOLD_MONTHS + ' months have been deleted.');
        Messaging.sendEmail(new Messaging.SingleEmailMessage[] { email });
    }
}

Apex Code

To schedule this batch Apex class to run at a specific time every day, you can use the System.schedule()

String cronExpression = '0 0 0 * * ?';  // Run every day at midnight
String jobName = 'InactiveAccountDeleter';
InactiveAccountDeleter batch = new InactiveAccountDeleter();
System.schedule(jobName, cronExpression, batch);

Prev You need to login to have access to the quizzes. MARK THIS AS UNDERSTOOD Next

Mastered by 15 users.

Integration Course

A. Apex REST Callouts (13 lessons)

B. GoRest API Integration (6 lessons)

C. REST Web Services (4 lessons)

D. Postman (6 lessons)

E. JSON (2 lessons)

F. SF to SF Integration (1 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 39 | Batch Apex | Inactive Account Deleter

Apex Class

Integration Course