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.

Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST??

Divya K1
Tera Guru

Schedule report should run only on weekdays(mon to friday) from 1 pm to 10pm IST?? exclude weekends

7 REPLIES 7

Harsh_Deep
Giga Sage
Giga Sage

Hello @Divya K1 ,

 

In the Schedule report use below code after checking the checkbox "conditional".

Harsh_Deep_0-1728546158032.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

Thanks harsha,

 

but i need to run the scheduled report between 1pm to 10pm IST ?

 

how to do this in script?

 

 

Hello @Divya K1 

 

In the given screen shot time is there, in that time column you can mention 13:00:00 to 22:00:00 any time, and in the run as tz then choose IST.

 

For your reference I have attached below screen shot.

Harsh_Deep_0-1728550422136.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

 

 

You just put in the time you need it to run. If you want it to run at 5 pm IST, you put the time at 5pm IST. The script Harsh_Deep provided will ensure it's on a weekday.

It makes no sense to have a scheduled report run more than once a day. If that is your question, please explain the business case.

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark