cancel
Showing results for 
Search instead for 
Did you mean: 

Table or SQL query to see Recent Activity for schedules

RobertWashingto
Level 2

Hi, wondering if you can help me.  Where can I see the data for 'Recent Activity' in the database tables?  I'm interesting in seeing when schedules failed, completed and are running.  Thanks.



------------------------------
Robert Washington
------------------------------
3 REPLIES 3

ÖzençGezgin
Level 4

Hi @Robert Washington

You can see In control Rooms and you can export the data.

Have a nica day...

31028.png



------------------------------
Özenç Gezgin
Supervisor
Türkiye İş Bankası A.Ş.
Europe/Istanbul
------------------------------

Babjee24
Level 7

Hi Robert,

Please use   select * from BPAScheduleLogEntry; for getting the in progress, completed and failed schedules. In my case I don't have any record as I've had a fresh installation. 

31029.png

Also have a look at  SQL Query - how to find future schedules



------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

Babjee Vangipurapu
Senior RPA Developer
India

How can I query BPAScheduleLogEntry and other tables to replicate the Recent Activity Report? I would like to know when a schedule fails to run a process, which is represented by the red X in the Recent Activity Report. 



------------------------------
Shannon Berlin
Business Process Specialist
Chesapeake Energy
America/Chicago
------------------------------