topic RE: Table or SQL query to see Recent Activity for schedules in Product Forum

Table or SQL query to see Recent Activity for schedules

RobertWashingto — Fri, 24 Feb 2023 09:59:00 GMT

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

RE: Table or SQL query to see Recent Activity for schedules

ÖzençGezgin — Fri, 24 Feb 2023 13:57:00 GMT

Hi @Robert Washington

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

Have a nica day...

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

RE: Table or SQL query to see Recent Activity for schedules

Babjee24 — Fri, 24 Feb 2023 16:21:00 GMT

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.

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

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

RE: Table or SQL query to see Recent Activity for schedules

sbass2 — Tue, 07 Mar 2023 23:38:00 GMT

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