Easy way to monitoring your process

[PabloSarabia]

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

[TobiasArnold]

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

[ramyaranganathan]

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