3

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

2

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.