I'm looking for help creating a Scheduled Job (script) that will run periodically during the day against the Entitlement table (service_entitlement). We have a true/false field on our Account table (customer_account) called u_sm_pts. We want that box checked (true) if there are any Active Entitlements with the Model Numbers (model_number) shown below.
Examples:
123-456789-001
123-456780-001
123-456779-002
123-456777-001
The box would be checked if only one of these Entitlements/Model Numbers is Active. If it doesn't find any Active Entitlements with these Model Numbers, then the u_sm_pts box would need to be unchecked (false).
