Schedule report for a time interval.

ROJA VANAMBADI
Tera Contributor

How can I schedule a report which will send an email daily to all the recipients at 9am during some time interval. Like I want to schedule the report to be sent from <Start Date> and <End Date>. For example, I want to schedule the report to be sent daily between 15 April, 2022 to 15 May, 2022.

I cannot find any way to do it, Please help me.

find_real_file.png

4 REPLIES 4

Sulabh Garg
Mega Sage
Mega Sage

Hello Roja,

Currently there is no option to specify time interval as 'start date' and 'end date', For now you can specify the Run field as 'periodically' and mention the starting as 2022-04-15 00:00:00. (15th April) and keep a reminder somewhere outside servicenow to deactivate this scheduled report after 15th May.

Hope it helps.

 

find_real_file.png

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

Please Mark ✅ Correct/helpful, if applicable, Thanks!!
Regards
Sulabh Garg

DrewW
Mega Sage
Mega Sage

So a scheduled report is a scheduled job. So you can schedule the report like @Sulabh Garg suggested then find the scheduled job record and create another scheduled job that will update active to false on the scheduled job record for the report that runs at the date and time you would like the report to stop going out.

I am not allowed to create any schedule job.

Isn't there any script which I can directly write while scheduling report, where we can write Start date and end date, and the report will be sent daily with those dates only?

 

find_real_file.png

Not that I have ever seen.

Can you create a flow?  You can use a flow to do the same thing.

Go to the idea portal and add this as an idea if its not already out there.