Dynamic Schedule of Bot

Help
#1

Hey,

I want to schedule the bot dynamically.
For ex: The bot runs at a particular time and reads a sheet containing schedule and in the sheet it’s written 2PM Tuesday and 4PM Wednesday, so the bot should be triggered on these two times.
How can that be accomplished?

1 Like
#2

We can define this in a schedule tab in orchestrator with CRON option under advanced schedule option itself
like we can define with two schedules For the same process with expression as

0 0 14 ? * TUE *

And another one with expression as

0 0 16 ? * WED *

Cheers @Anmol_Yadav

#3

@Palaniyappan This will not work as the sheet will always not have this value, it may change, so we will have to read the sheet and then make the schedule.

#4

Fine
It’s possible to use Orchestrator API to trigger a job. As such, you could have a separate tiny process that reads the Excel file every 5 minutes or so and triggers the main job if the cells were updated.

Cheers @Anmol_Yadav

1 Like
#5

Hi @Anmol_Yadav

Why you want to make complex the thing, just create one variable in the start of the process .

Read the excels , can check there is data or not with excel read / or read cell value , etc. there is alot you can use.

if find data ,run if not don’t run.

hope it helps. :slight_smile:

#6

I know that. i am asking the solution for the same. how to do it? has someone implemented it ever?

#7

@Alvin
That’s the business scenario, i have to schedule it via orchestrator API only.