Reporting Schedules - Weekdays only

[narelle_s]

Hi,

I've scoured the forum and the Wiki for answers to this, but cannot find an answer.

If a user only wants to schedule report for Weekdays, how do I do it? I can see there is a suggested script code for scheduling a script to exclude Saturday & Sunday, but how can I apply that to a scheduled report?

There is no Business Day type Calendar or Schedule, in the report options for a scheduled report, so other than creating 5 schedules, one for each day of the week, what's the answer?

Thanks
narelle

[jquinonez]

Hi Mark,

Could you provide an example of setting the 'condition' field with the client script? We could probably do this manually, but it would be nice to automate this.

Thanks

[Mark Stanger]

You can just use 'g_form.setValue'. You just need to take each line of the script and add it to a string variable, then set the field with the variable value.

[jquinonez]

Thanks!

[Pastupe]

Hi, I had a same question from manager if it is possible to schedule report only for workdays.

My thinking without developing anything is , that report could be scheduled not one time, but 5 times for each work day separatelly as on the below image you can see that if you select to run report WEEKly, then you can select exact day.

If you do it once per work day = 5x scheduled report, finally this is the solution that you get reports only in work days.

But the question I do have, is how this could be done to send report only in defined schedule (business hours) ?

Petr

[FIKRI BENBRAHIM]

Hello guys,

   Please refer to that link that speaks about schedules and how to use them in order to get the working days of a Domain:  https://www.servicenowguru.com/system-definition/weekdaysonly-scheduled-job/.

   For your case the scheduled job should be conditional (Conditional check box) and in that condition put the GlideRecord over the schedule's table record relative to your domain (if your instance is domain separated).

Best regards

FIKRI BENBRAHIM Mohamed Jawad