Best practice to generate requests with predefined intervals

[j0unss]

Hello,

We have a requirement that certain requests should open regularly at predefined intervals. What would be the best way to implement this? I noticed that Scheduled Jobs directly provide the ability to generate a request via a template, but the scheduling options seem too limited for our needs. Requests should be generated, for example:

• Every third Tuesday of the month
• One (1) day before the second Wednesday of every month
• Every first Friday of every fourth month

As it stands, Scheduled Jobs do not seem to offer enough options Out-of-the-box for our requirements.

[mads2]

Actually you can obtain these specific requirements in the scheduled job.

Set the Run type to Business Calendar: Entry Start and then define a business calendar containing entries with the specific dates you want the scheduled job to trigger.

The only drawback is that you need to maintain the business calendar in the future.

[j0unss]

Thanks @mads2! 

What I understood from this: "In contrast to legacy schedule entries that have repeating and excluding time spans, you have to create individual business calendar entries for every business calendar time span. For example, if you are creating a Fiscal Year 2020 business calendar with 13 fiscal periods, you have to create individual business calendar entries for each fiscal period. For each fiscal period, you specify start and end date times."

It looks like we have to create all the business calendar entries ourselves? With our needs, we have to create few hundred calendar entries. Or am I able to combine scheduled entries with business calender somehow, for example which creates all the entries automaticly. I tried, but Scheduled Job says: "Job is set to run at the start of 3rd tuesday of each month entries, next action is: 3000-02-02 16:00:00".

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/time/task/defin...

[mads2]

You can probably create a script or a flow to create automatically

Personally I would create a spreadsheet with all the entries needed and then create the entries using a data load and a transform map. With a few excel skills I think it is quite quick to create the entries needed.