Batch Job - Delete Inactive Application Scorecards

Inactive application scorecard result records are meant for audit purposes and the Banks/FIs clear them on a regular basis. These inactive application scorecard result records filling up storage space in Salesforce Org as there is no mechanism, other than manual intervention, to delete such records in the system. Also, storage space is a concern in terms of the cost of space.

Now, you can execute ApplicationScorecardResultCleanupJob to delete the inactive application scorecard records ( as these records are filling up the space) from the database. These deleted records are stored in Salesforce's recycle bin and you can restore those as well.

You can define the age of the records that need to be deleted in the custom metadata type Batch_parameters, which is used to configure values of batch parameters. The age parameter determines how old the records should be before deletion. 

Prerequisites

None.

Steps

To configure and execute ApplicationScorecardResultCleanupJob:

1. Log in to your Salesforce account.
   

2. Select (Setup), and then select  Setup.
   

3. In the Quick Find box, search for Apex Classes and select it.

4. Select Schedule Apex and perform the following actions, and then select Save:

   Note:

   All the fields are mandatory.

   Field name		Action
   Job Name		Specify a unique name for the job to identify it
   Apex Class		Search for ApplicationScorecardResultCleanupJob and select it.
   Schedule Apex Execution	Frequency	Select a frequency based on your requirement. It can be Weekly or Monthly.
   	Start	Select a start date for the job
   	End	Select an end date for the job
   	Preferred Start Time	Select a time when you want to run the job

5. Once the job is scheduled, you can view that on the Scheduled Jobs page (Go to the Quick Find box, search for Scheduled Jobs and select it.).

6. If you want to specify the age of the data to be deleted, perform the following steps:

   1. In the Quick Find box, search for Custom Metadata Types and select it.

   2. Select Manage Records for the Label Batch Parameter.

   3. Select Edit for the Label RuleEvaluationResult records cleanup age and specify the age of the data in the Parameter Value field.
      

      Note:

      • If the Parameter Value field is not available in the UI, drag and drop the field by editing the page layout.

      • This value determines how old the records should be before deletion. The default value is 5 for the Parameter Value field.

      • This parameter is also used by the following batch jobs:

        • Batch Job- Delete Rule Evaluation Result

        • Batch Job- Delete Rule Evaluation Result

7. To view the status of the job, go to the Quick Find box, search for Apex Jobs and select it.

   Note:

   The job status can be Failed if the records are locked.

   To override the configured age parameter, the following parameter can be passed to the class directly:

   ApplicationScorecardResultCleanupJob job = new ApplicationScorecardResultCleanupJob(age of the record to be deleted);

   Batch.execute(job);