SQL Query - how to find future schedules
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-08-20 09:30 AM
I was able to find that BPAScheduleLog holds schedule that already started, but which table in DB hold the "calendar" of future schedules
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-08-20 02:55 AM
Hey Marek,
Are you looking to figure out when schedules will be triggered? If so, BPAScheduleTrigger is where you can find all available schedules. If you are specifically looking to filter only future schedules, you will need to write a query to join information from BPASchedule and BPAScheduleTrigger.
Hope this helps!
Regards.
------------------------------
Madhur Chopra
Sr. Product Consultant
Blue Prism - Professional Services
America/Los_Angeles
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-08-20 01:54 PM
SELECT TOP (1000)
[scheduleid]
,[name]
,[period]
,[startdate]
,[enddate]
,[startpoint]
,[endpoint]
FROM [BPAScheduleTrigger] JOIN [BPASchedule] ON (BPAScheduleTrigger.scheduleid = BPASchedule.id)
where startdate > '2020-08-30'
order by startdate desc
------------------------------
Marek Pawlowski
RPA Developer
Digital Workforce
Europe/Warsaw
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-08-20 09:41 PM
SELECT
[scheduleid],
[name],
[period],
[startdate],
[enddate],
[startpoint],
[endpoint]
FROM [BPAScheduleTrigger] JOIN [BPASchedule] ON (BPAScheduleTrigger.scheduleid = BPASchedule.id)
WHERE [BPASchedule].retired = 0
ORDER BY [startdate] DESC, [name]
------------------------------
Brenton Westwood
Systems Analyst
Southern Company
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-08-20 09:50 PM
SELECT [scheduleid]
,[name]
,[instancetime]
,[firereason]
,[servername]
,[heartbeat]
FROM [BPAScheduleLog] JOIN [BPASchedule] ON (BPAScheduleLog.scheduleid = BPASchedule.id)
WHERE [BPASchedule].retired = 0
ORDER BY [instancetime] DESC, [name]
------------------------------
Brenton Westwood
Systems Analyst
Southern Company
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-09-20 01:01 PM
Dont know how to deal with it, not everything is showing or not even one future schedule...
------------------------------
Marek Pawlowski
RPA Developer
Digital Workforce
Europe/Warsaw
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-09-20 02:42 PM
------------------------------
Brenton Westwood
Systems Analyst
Southern Company
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-09-20 03:56 PM
------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------