I have a requirement to create a batch class for Tenant__c object for the Property management app. The condition is when our Tenant doesn't pay rent by the beginning of the month, we send him/her an email with a reminder. There is a field called "Status" on Tenant object if the status is not "Paid" then send email.I wrote a batch class but I am not sure where do I put condition to send emails? In Execute or Finish?Please Help!global class TenantLatePaymentTask implements Database.Batchable<SObject> { global Database.QueryLocator start(Database.BatchableContext BC) { return Database.getQueryLocator([ SELECT Name, Id, Email_Address__c,description__c from Tenant__c Where Status__c='Non-Active']); }global void execute(Database.BatchableContext BC, List<Tenant__c> tenants) {list<Tenant__c> TenList=new list<Tenant__c>(); for (Tenant__c tenant : tenants) {tenant.description__c='Last Payment is missing. Please Follow up with the Tenant';TenList.add(tenant); } list<Messaging.SingleEmailMessage> mails = new List<Messaging.SingleEmailMessage>(); for (Tenant__c Ten :TenList ) { if (Ten.Email_Address__c != null && Ten.Status__c!='Paid') { Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); List<String> sendTo = new List<String>(); sendTo.add(Ten.Email_Address__c); mail.setToAddresses(sendTo); mail.setReplyTo('dreamhouse@gmail.com'); mail.setSenderDisplayName('Dreamhouse real estate Co'); List<String> ccTo = new List<String>(); ccTo.add('business@bankofnigeria.com'); mail.setCcAddresses(ccTo); mail.setSubject('Last Rent Payment is Missing'); String body = 'Dear ' + Ten.First_Name__c + ', '; body += 'Please, submit your last rent payment'; mail.setHtmlBody(body); mails.add(mail); } } Messaging.sendEmail(mails); if(TenList!=null && TenList.size()>0){ database.update(TenList);}}global void finish(Database.BatchableContext BC) { }}
