how can we send a Scheduled report excluding weekends?

Shrestha4
Kilo Contributor

I want to send Scheduled Report excluding weekends? 

When we go to scheduled report and and set RUN field as periodically and send report daily, I want to exclude weekends.

How can I achieve this?

 

find_real_file.png

9 REPLIES 9

Dhananjay Pawar
Kilo Sage

Hi,

Check below links,It may help you.

https://community.servicenow.com/community?id=community_question&sys_id=5f615b2ddbdcdbc01dcaf3231f961945

https://community.servicenow.com/community?id=community_question&sys_id=9201808fdb94d34c0e58fb651f9619be

 

Thanks,

Dhananjay.

Hi,

Did this solve your question? Or do we need to follow-up on this?

Please mark this answer as correct if it solves your question. This will help others who are looking for a similar solution. Also marking this answer as correct takes the post out of the unsolved list.
Thanks.

Regards,
Dhananjay.

Hi Shrestha,

Could you mark this as correct so others will refer same in future for same query.

 

Thanks,

Dhananjay.

Kamlesh Pimple
Mega Expert

Hi,

 

You need to add a new checkbox to the scheduled report form called 'Weekdays'.
http://www.servicenowguru.com/system-definition/weekdaysonly-scheduled-job/

You'll want to add some client scripts and UI policies to make this work correctly.

1) A UI policy that displays and hides the 'Weekdays' checkbox when the 'Daily' Run value is changed. It should also set the 'Weekdays' checkbox to false if the Run value is not 'Daily'.
2) A client script that sets the 'Condition' field with the script and makes it readonly when the 'Weekdays' checkbox is checked. It should also do the opposite when the 'Weekdays' checkbox is set to false.

 

Hope it helps,

 

If my answer helped you in any way, please then mark it as helpful.

 

Regards,

Kamlesh.