How to get a report to run on the 2nd Wednesday of every month

[sarahjantz]

We're trying to create a report that runs on the second Wednesday of every month. What is the best way to accomplish this? We were trying to accomplish this with the use of a Business Calendar, but when we select those options, there isn't a field to select the calendar. 

[SAI VENKATESH]

Hi @sarahjantz 

For Your Requirement you can use schedule Job :

Navigate to System definition ---> Schedule Jobs and Interceptor will be opened and based upon the requirement you can select the following.

After the creation of the schedule job, you need to do the following steps:

Navigate to "Reports > View / Run" in your ServiceNow instance.

Create or open the report you want to schedule.

Click the "Schedule" button.

Configure the schedule for the report:

Active: True

Run: Periodically

Time: Set to a time that matches the time you set in the Scheduled Job script.

Thanks and regards

Sai Venkatesh

[Rampriya-S · Accepted solution]

Hi @sarahjantz 

You can try this logic, weekly report schedule run on every Wednesday if the day of the month is 5-11 that means 2nd week of the month.

Mark helpful if you accept the solution.

[sarahjantz]

Thank you. This worked, except we had to change the day of the month logic from 5-11 to 7-14. This month's Wednesday fell on the 12th so the report didn't initially run until we changed it to this. 

[Rampriya-S]

@sarahjantz If the solution is helpful, please give thumbs up. We are spending some time to finding the solution.