Scheduled job for email cleanup

Go to solution
Rashmi11
Tera Contributor

‎04-19-2022 06:06 AM

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();
}

0 Helpfuls
  • 1,006 Views
1 ACCEPTED SOLUTION

Go to solution
Community Alums
Not applicable

‎04-19-2022 06:11 AM

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

0 Helpfuls
6 REPLIES 6

Go to solution
Rashmi11
Tera Contributor
In response to Community Alums

‎05-03-2022 04:35 AM

Thanks Sandeep. It worked

0 Helpfuls

Go to solution
Rashmi Bansal
Mega Guru
In response to Community Alums

‎04-25-2024 03:52 AM

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

0 Helpfuls