Conditional Scheduled Report to run only on certain days and certain times

[Community Alums]

FYI, In Orlando, Glide classes such as GlideDate, GlideTime and GlideDateTime are no longer working on a conditional script in a Scheduled Report.

Knowledge Article from HI: https://hi.service-now.com/kb_view.do?sysparm_article=KB0827366

So, the workaround is to use Date() JavaScript object instead on Glide classes offered by ServiceNow.

Example: Below is the Scheduled Report which runs every 4 hours starting from Saturday 1st Aug 10AM till Monday 8AM

1. Create a Report
2. Go to Scheduled Report – Create New – Add the Report to it and set Run to Periodically and set Repeat Interval and Starting time to trigger the Schedule Report.

[froehre31]

This is great!  I"m glad you incorporated the Orlando issue into this.  Can you help me with the script to run Monday - Friday between the hours of 8 am and 5 pm?  I tried modifying what you have but it seem to still be running when testing with different days.

[Community Alums]

Hi,

Sorry for the late response, did the issue got resolved?

[Josh Flora]

Hello Anusha!

I found your article here and I hate to dig something up this old but I am also wanting to only send a scheduled report for specific days of the week only between 8-5 (business hours.)  I did try what you wrote above and it's sending regardless, like froehre31 is stating.