There are several ways to trigger this, and they are fairly equivalent, you can choose the one you prefer as a matter of taste
The cron job with PHP script sounds like a good option. If you want to manage this from within SuiteCRM, make it a SuiteCRM custom Scheduler job (there is a chapter in docs about Scheduler jobs that explains this) and set it’s regularity in Admin / Schedulers.