Scheduled Email Report

BibekP
Tera Contributor

Hi Team,

 

I want to scheduled the report three times a day 8:00 AM, 10:00 PM and 2:00 AM. How can I do this?

 

Thanks

2 REPLIES 2

Sai Shravan
Mega Sage

Hello @BibekP , 

Good Day !

- Please refer to the below document for the ask !

Schedule emails of reports : 

https://www.servicenow.com/docs/bundle/washingtondc-now-intelligence/page/use/reporting/task/t_Sched...

Regards,
Shravan
Please mark this as helpful and correct answer, if this helps you

Ankur Bawiskar
Tera Patron
Tera Patron

@BibekP 

2 methods

1) have 3 different scheduled reports 1 each at 8am, 10pm and 2am

OR

2) have single scheduled report which runs periodically every 1 hour and it will use script in condition field to check what's the time, if the time matches then condition will be true and report will be sent

something like this

var gdt = new GlideDateTime();
var currentTime = gdt.getDisplayValue().split(' ')[1]; // Get the current time in HH:mm:ss format

// Define the times to check
var timesToCheck = ['08:00:00', '22:00:00', '02:00:00'];
if (timesToCheck.indexOf(currentTime) !== -1) {
    answer = true;
} else
    answer = false;

AnkurBawiskar_0-1744859476835.png

 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader