Hi @Dizy M,

Please follow the steps below

1. Create a new Event (Event > Registry) on Assessment Instance table
2. Create a new Email > Notification for the assessment instance table) and associate the above event

3. Ensure your notification has

   • Send to event Creator true
   • Event parm1 contains recipient as true
4. Create schedule job which runs daily and checks the records and sends notification to the user

Script:

sendNotification();

function sendNotification(){

try{
var gr = new GlideRecord('asmt_assessment_instance');
gr.addEncodedQuery('stateINready,wip^userISNOTEMPTY');
gr.query();
while (gr.next()) {
	gs.eventQueue('event_name', gr, gr.user, '');
}
}
catch(ex){
gs.info(ex);
}

}