Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,191 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