topic Easy way to monitoring your process in Product Forum

Easy way to monitoring your process

PabloSarabia — Tue, 13 Apr 2021 13:16:00 GMT

#BPTechTips
#TipOfTheDay

Hi everyone!

I want to open a dicussion about unattended monitoring of processes.

Here I post you a simple query for the Blue Prism Database to see the status of the workers.

SELECT sessionnumber
, PROCESS.name
, RESOUR.name
, startdatetime
, enddatetime
, SES.lastupdated
, SES.laststage
, CASE WHEN SES.statusid = 1 AND DATEDIFF(minute,SES.lastupdated,getdate()) >= 5 THEN 'Warning' ELSE STAT.description END AS [status]
FROM BPASession SES
INNER JOIN BPAResource RESOUR ON SES.runningresourceid = RESOUR.resourceid
INNER JOIN BPAStatus STAT ON SES.statusid = STAT.statusid
INNER JOIN BPAProcess PROCESS ON SES.processid = PROCESS.processid

WHERE sessionnumber IN (SELECT MAX(sessionnumber) FROM BPASession GROUP BY runningresourceid)

I create another program to check every 5 minutes about the status. If the "watcher" see any "stoped" or other issue, it send me an email.

What do you think about this? I think it's awesome to have a robot watching the robot.

Bye 🙂

------------------------------
Pablo Sarabia
Programmer
Altamira AM
------------------------------

RE: Easy way to monitoring your process

TobiasArnold — Tue, 13 Apr 2021 13:42:00 GMT

Hi Pablo,

thanks for sharing. We use a similar approach in our self written scheduler. Here we concat Blue Prism processes to a job. Like 'Login' - 'Load Work Queue' - 'Process Work Queue' - 'Write Report' - 'Logout'.
Our scheduler uses this piece of code to monitor the running process and start the next step when the actual step last finish.
Our SQL runs every 20 seconds. But we do not join any other tables,
Another tip: Execute the sql 'WITH NOLOCK' to prevent database locks.

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

RE: Easy way to monitoring your process

ramyaranganathan — Thu, 02 Dec 2021 10:38:00 GMT

Hi Pablo,

how did you get the below part done

I create another program to check every 5 minutes about the status. If the "watcher" see any "stoped" or other issue, it send me an email.

------------------------------
Ramya Ranganathan
senior system engineer
shell india
------------------------------