Control Room & Scheduler

Expand all | Collapse all

Dynamic Scheduling for processes

  • 1.  Dynamic Scheduling for processes

    Posted 10 days ago
    Hello,
    I would like to know how can I change the scheduler start time and/or other scheduler data from a process by changing the Blue Prism metadata through backend (like SQL query).

    Let me try to give the scenario/requirement,
    Suppose Process-1 is scheduled to run at 6 AM through a scheduler named Scheduler-1. But business may want to run it at 8 AM for a particular day as per their need. This change may be ad-hoc and very frequent.
    But business has no access to Blue Prism environment. They will use and update one DB table (say BusinessScheduler) which will contain the scheduler related info (like start time) for Process-1.
    I have another Process-2 which will constantly check the BusinessScheduler table and update the scheduler information of Scheduler-1 in Background Mode using SQL query to the Blue Prism database.

    Does this make sense?

    Is this possible? If yes, what are the Blue Prism table and which fields we need to update to reflect the update in the scheduler instantly.

    ------------------------------
    Debasish Mondal
    ------------------------------


  • 2.  RE: Dynamic Scheduling for processes

    Posted 10 days ago
    I know this can be achieved by triggering through web service call but with some infrastructure change in production system.
    So, trying to find the solution through scheduler first.

    ------------------------------
    Debasish Mondal
    ------------------------------



  • 3.  RE: Dynamic Scheduling for processes

    Posted 10 days ago
    Schedules are listed in BPASchedule. The actual timing of the schedule can be found in BPAScheduleTrigger. Somehow these tie into BPAScheduleListSchedule, referencing the scheduleid from BPAScheduleTrigger (which also matches id in BPASchedule), as well as a corresponding schedulelistid matching column id in BPAScheduleList.

    ------------------------------
    Ami Barrett
    Lead RPA Software Developer
    Solai & Cameron
    America/Chicago
    ------------------------------



  • 4.  RE: Dynamic Scheduling for processes

    Posted 8 days ago
    Hey just curious about the variables that you are referring to in this post like BPASchedule, BRPScheduleTrigger, BPAScheduleListSchedule. Could you explain to me where you are finding/using these?

    ------------------------------
    Andrew Randolph
    Analyst
    Accenture
    America/New_York
    ------------------------------



  • 5.  RE: Dynamic Scheduling for processes

    Posted 8 days ago
    Those are table names out of the BP Database. Everything else referenced were columns within them.

    ------------------------------
    Ami Barrett
    Lead RPA Software Developer
    Solai & Cameron
    America/Chicago
    ------------------------------