topic list of current schedules in Product Forum

list of current schedules

sumire — Tue, 12 Dec 2023 06:54:00 GMT

Hi all,

I'm looking for a way to get a list of schedules for a specified period of time.
Is there a way to get a list of schedules for a given period?

Thank you for all your help.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: list of current schedules

Rambo27 — Tue, 12 Dec 2023 08:15:00 GMT

Hi Mitsuko,

You can take reference from database and check for specific time.

------------------------------
Shikhar Mishra
RPA Lead
Infosys
------------------------------

RE: list of current schedules

sumire — Thu, 14 Dec 2023 09:44:00 GMT

Hello @Shikhar Mishra,

Thanks for reply.

I'll try to retrieve data from a table in a Blue Prism database using OLEDB VBO.

Please advise me if you know of a more appropriate method.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: list of current schedules

Walter.Koller — Thu, 14 Dec 2023 13:29:00 GMT

Blue Prism does not store upcoming schedule date and time but the definition only. The upcoming date/time is calculated as needed.

Otherwise, if all upcoming schedules would be calculated and stored, all those records would need to be updated for every change in schedule.

~~Or are you interested in a list of schedules executed in the past?~~ (as your title already stated: 'current schedules')

------------------------------
Walter Koller
Solution Manager
Erste Digital / Erste Group Bank
Europe/Vienna
------------------------------

RE: list of current schedules

sumire — Fri, 15 Dec 2023 00:07:00 GMT

Hello @Walter Koller,

Thanks for reply.

You are right, I want to get a list of "schedule definitions".
If possible, I would like to extract "what is scheduled for a given time period" and "what are the settings for that schedule", which I can get by filtering it once I get the "entire schedule definition".
Future schedules can be calculated based on that.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: list of current schedules

LeonardoSQueiroz — Mon, 18 Dec 2023 02:34:00 GMT

Hello,

You can check which schedules are active:

SELECT

[name]

FROM [BluePrismD].[dbo].[BPASchedule] WHERE [name] IS NOT NULL"

I imagine that you will need to perform an inner join of this search, probably with another scheduling table.

Regards,

------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------