list of current schedules

[sumire]

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
------------------------------

[Rambo27]

Hi Mitsuko, 

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

 

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

[sumire]

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
------------------------------

[Walter.Koller]

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
------------------------------

[sumire]

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
------------------------------

[LeonardoSQueiroz]

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
------------------------------