Batch Processes - Scheduled & One-Time

Content

Hi,

    I just wanted to share a recent solution I did for handling batch processes - scheduled & one time. 

Usually, I see people suggesting Multi Edit Workspaces & Cron jobs (scheduled batch processes) to handle batch processes. 

But, both have limitations or not very flexible (cron job). 

An Alternative solution, is to use Analytics Reports with custom scripts (PHP). 

Sample Requirement

Assume Incident has custom field - Expiration Date. 

Query all Incident records which have Expiration Date = Today(). Then, update the Status = Expired. 

Analytics Report

1. Create a new grid report based on Incident. 
2. The first field must be Incident ID.