Weekly reminder for the leaners who are in Not Started and Inprogress status in self paced trainings

Summary:

Dear Experts,

Could you please suggest creating a weekly reminder alert (every Monday) for the learners in Not Started and In Progress status for the training?

Content (required):

The Reminder alert needs to be sent for the required assignments

Version (include the version you are using, if applicable):

23C

Code Snippet (add any code snippets that support your topic, if applicable):

I have used the below filters.

lastRun Expression is

exists (SELECT 'x' from dual where ${assignmentCreatedDate} >= (select nvl(max(runs.run_end),sysdate-1) from hrc_alert_runs runs, hrc_alerts_b alerts where runs.alert_id = alerts.alert_id and alerts.alert_code = '06E2B6E31AE23FCDE0630764310A5394'))