Scheduler process start to Fail

[vigneshShankar]

Hi Everyone,

I have a one minor query in BP scheduler functionalities like is there any way we could get alert /Notification ? when the scheduler process fail to start as per the scheduled time period due to (Resource not in active state) .

Instead of we have to manually go to check in scheduler --> report ->> Recent activity .  I would like to know alternative option if the scheduler process fail as per the time period.

Thanks
Vignesh.S


------------------------------
vignesh Shankar
------------------------------

[PabloSarabia · Accepted solution]

Hi @vignesh Shankar

I understand that your problem is that the previous session has not started, and the new scheduler session could not be started.

You have a complete log in the DataBase​. You will get something similar to this: (Table [BPAScheduleLogEntry])

Here you have a complete query to get it easy:

SELECT [name] AS ScheduleName
   , BPLog.id
   , BPLog.servername
   , BPLog.instancetime
   , BPLogEntryEnd.entrytime AS EndTime
   , BPLogEntry.terminationreason
FROM [BPASchedule] BPSche
   INNER JOIN [BPAScheduleLog] BPLog ON BPSche.id = BPLog.scheduleid
   INNER JOIN [BPAScheduleLogEntry] BPLogEntry ON BPLog.id = BPLogEntry.schedulelogid AND BPLogEntry.entrytype IN (2, 5, 8)
   LEFT JOIN [BPAScheduleLogEntry] BPLogEntryEnd ON BPLog.id = BPLogEntryEnd.schedulelogid AND BPLOGEntryEnd.entrytype in (1,2)
WHERE BPLog.instancetime > DATEADD(DAY,-1,GETDATE())


This query gives you only the Schedule Errors. For more info, you can change a little bit the query by removing the filters with the EntryType Field.

Here you have the relation between the number and description

0 = Start of schedule
1 = End of schedule, success
2 = End of schedule, exception
3 = Start of task
4 = End of task, success
5 = End of task, exception
6 = Start of session
7 = End of session, success
8 = End of session, exception


You can create another Process to check this query results

Also, I will give you some information about Alerts in BluePrism. Really interesting if you want to create a process to check the status of the rest of the Schedules

Blue Prism Alerts
Blue Prism Alerts Configuration

(Check your BP Version to see if you have this functionality)


Hope this helps you. And if this solves the problem, remember mark as the best answer!


See you in the Community, bye :)

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
634726270
------------------------------

[shashank.kumar280]

Hi Folks,

To add to the thread, it would be worth looking at this asset on DX as well that can automatically monitor and send notifications for misfired schedules in a Blue Prism environment

https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism-schedule-monitor 


------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------