Scheduled job for email cleanup

Rashmi11 · ‎04-19-2022

I want to create a scheduled job to delete all undelivered emails for today. Tried doing this with below script but its not working:

var emailGr = new GlideRecord('sys_email');
emailGr.addEncodedQuery('sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^sys_idISNOTEMPTY^subject=Undelivered Mail Returned to Sender');
emailGr.query();
var count = emailGr.getRowCount();
while(emailGr.next()){
var grReport = emailGr.sys_id.getRefRecord();
if(grReport.isValidRecord())
grReport.deleteRecord();
}

Community Alums · ‎04-19-2022

Hi @Rashmi ,

Something like below should work. Elevate your privileges and execute below script from background.

var gr=new GlideRecord('sys_email');

gr.addQuery('type','send-ready');

gr.deleteMultiple();

You can also change the type to send-ignored rather than deleting those.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

View solution in original post

Rashmi11 · ‎05-03-2022

Thanks Sandeep. It worked

Rashmi Bansal · ‎04-25-2024

send-ignored and received-ignored can be deleted right?