Lesson: 37 | Batch Apex | Update Records

Create a Batch Apex class which updates all the cases priority to High if their status is new. The program should email the owner of the job with details.

Code
Video

Code

Apex Class:

global class UpdateCases implements Database.Batchable<SObject>{
    global final String query;
    global Database.QueryLocator start(Database.BatchableContext bc) {
        return Database.getQueryLocator(query);
    }
    global void execute(Database.BatchableContext bc, List<Case> scope) {
        for(Case cs : scope){
            if(cs.Status=='New'){
                cs.Priority='High';
            }
        }
        update scope;
    }
    global void finish(Database.BatchableContext bc) {
        
        AsyncApexJob job = [select Id, Status, NumberOfErrors, JobItemsProcessed, TotalJobItems, CreatedBy.Email From AsyncApexJob where Id = :bc.getJobId() ];
        Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
        String[] toAddress = new String[]{job.CreatedBy.Email};
            mail.setToAddresses(toAddress);
        mail.setSubject('Apex job Status' + job.Status);
        mail.setPlainTextBody('The apex job processed ' + job.TotalJobItems + ' Batches with ' + job.NumberOfErrors + ' failures');
        Messaging.sendEmail(new Messaging.SingleEmailMessage[] {mail});
        
        
    }
}

Apex Code (Execution):

UpdateCases objA = new UpdateCases();
objA.query = 'SELECT Id, Status,Priority FROM Case';
Database.executeBatch(objA,100);

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

Mastered by 15 users.

Exercises

A. Administrator | Exercises (59 lessons)

B. Flow Builder | Exercises (41 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (90 lessons)

E. Integration | Exercises (4 lessons)

F. Lightning Web Component (LWC) Exercises (14 lessons)

Go to top

Login to your account

Lesson: 37 | Batch Apex | Update Records

Code

Exercises