How to create a 'Smart agent'

I would like to create a ‘Smart agent’.
I have a site with a member’s area, a database, dynamic pages & a filtered search - used as a Job board.
I would like members to be able to choose to receive a periodic email notifying them with data changes (new jobs that were posted) that meet their criteria.
For example - a weekly/daily email with the new Accountant positions at a certain location.

Basically, I have two issues to solve:

  1. I need to trigger the email every day/week/month and not only the first time a member is setting his criteria. The WIX triggered email I found triggered only when a member performed an action.
  2. I need one email to contain all the data changes during the set period of time & not a separate email for each data change.

I found the below thread from 2017, however I need more information to be able to implement it and I was wondering if there is any new material on this subject.
https://www.wix.com/corvid/forum/community-discussion/creating-a-smart-agent/p-1/dl-598af7c5e5915a00102331dd

Hi @omri ,

Here are some way you can solve your issue:

  1. You can use a recurring job to trigger your code every morning:
    https://support.wix.com/en/article/corvid-scheduling-recurring-jobs .
    Use the scheduler to trigger a script that send your emails. (Keep in mind that script can only run for 14 seconds, so if you have too many emails that might not be the solution).

  2. To keep track of the change have a column ‘lastEmail’ with the date of the last sent email. Then query all the events that occured since that time. Combine them into an email and send them.

Overhaul, I think Wix triggered email is not a good fit for your use case. I would recommend using a scheduled job to send emails via an API such as mandrill (API for MailChimp).

Thank you @plomteuxquentin ,
Not the answer I was hoping for…