cancel
Showing results for 
Search instead for 
Did you mean: 

An action exists for getting Scheduler Name, for which an item has been updated?

TeresaFrazão
Level 2
Hello All, Similar to action responsible for getting a Machine Name (Utility - Environment > Get Machine Name), an action exists for getting the scheduler at which an item was updated? Thus, we have a process that executes 4 times a day, and for the same process we have 4 schedulers created. Business requires knowing in which scheduler cycle a particular item has been updated (thus, BoD, Afternoon, Closing, EoD). Thank you in advance for your assistance on this regards. Best regards, Teresa
2 REPLIES 2

TomCirone
Level 6
GetSessionId is a function that retrieves the session for the run.  From there you can query the Blue Prism database to find the schedule name with the below query.  I think that's the only way to get the schedule name currently.   SELECT distinct name FROM [dbo].[BPASession] s JOIN [dbo].[BPAScheduleLogEntry] le on s.sessionnumber = le.[logsessionnumber] JOIN [dbo].[BPAScheduleLog] schedlog on le.[schedulelogid] = schedlog.id JOIN [dbo].[BPASchedule] sched on sched.id = schedlog.scheduleid   WHERE sessionid = '""&[Session ID]&""'

AmiBarrett
Level 12
Alternatively, configure your start stage with a text input of your schedule name. You should then be able to fill it in from the scheduler and reference that variable.