How to schedule the BOT Nth business day of every month

VJR

Well-Known Member
Hi KaliRaj1982,

There doesn't appear to be a direct option in BP to run a process on a specific business day of the month.
So definitely a new logic has to be built on our own.
There are vbscripts available on the web that calculates/returns the business day of the month.

(You can even have an Excel macro written where you can store the list of holidays in a tabular format and return the business day of the month. This macro can be easily called from within a script file like .vbs).


You can add a condition to the script file such that it will run the Blue Prism process only if today's date is the date of the desired nth business day calculated by the script.

Schedule the vbscript (or a .bat batch file) in the Windows Task Scheduler.
Although the Scheduler will run the script file everyday at the time you configure it, but it will start the Blue Prism process only if the condition of the nth business day matches as mentioned above.

Below link (and the links in it) will be helpful to you in achieving this.
http://rpaforum.net/threads/send-mail-every-hour-and-every-day.965/


Edit1: Instead of the scheduler a call can also be made from Blue Prism.
An option is to design a macro that will return True (or write "True" to some cell) if today's date is the Nth business day.
This macro can be called from Blue Prism using the Ms Excel VBO. So a BP process will run everyday to run this macro.
If the macro returns True then it means its time to run your other Process which you want to run only on the Nth business day.

Edit2: Now when I think of this more you can try to create the logic for finding out the Nth business day in the Blue Prism process itself (which will run everyday) and then call the other process from the first process if today is the Nth day.
 
Last edited:
Top