I have SugarBPM process (formerly known as Advanced Workflow) that sends an email when a field in Meetings module changes to 1. The value of this field is set by a Scheduled Job, which runs a MySQL query like this: $Query = " UPDATE meetings m JOIN meetings_cstm…