Writeback Matrix Scheduler - Priority queue

Introduce priority-based scheduling and execution for subscriptions to ensure that high-priority subscriptions are processed before lower-priority ones, aligning with business needs and user expectations.

Note: This Option is available only for On-Prem Users

Managing multiple report subscriptions is easier with the Priority option - you can control which subscription takes precedence.

  1. Subscription Priority Levels

    • Define and support the following priority levels:

      • High Priority

      • Medium Priority

      • Low Priority

    • Each subscription will have an associated priority level. If no priority is explicitly set, assign a default priority (e.g., Medium).

  2. Priority-Based Scheduling

    • Subscriptions will be scheduled based on their priority level.

    • High-priority subscriptions should always be scheduled ahead of medium or low-priority subscriptions.

  3. Priority-Based Execution

    • During execution, subscriptions must follow the priority order:

      • Execute all high-priority subscriptions first.

      • Then process medium-priority subscriptions.

      • Finally, execute low-priority subscriptions.

    • Within the same priority level, maintain the order based on the time of subscription creation (FIFO—First In, First Out).

  4. Dynamic Priority Adjustment

    • Allow priority levels to be updated dynamically for a subscription (e.g., upgrade a low-priority subscription to high priority).

    • Updated priorities should take immediate effect, ensuring the subscription is re-ordered in the scheduling queue accordingly.

  5. Error Handling

    • If a high-priority subscription fails, it will be retried before moving to lower-priority tasks.

    • Maintain retry attempts in accordance with existing retry policies.

  6. Monitoring and Reporting

    • Provide visibility into the current queue of subscriptions, categorized by priority levels.

    • Include metrics such as:

      • Number of subscriptions at each priority level.

      • Current execution order.

  7. Scalability

    • Ensure the system can handle a high volume of subscriptions across all priority levels without degradation in performance.

Frequently Asked Questions

1.      Priority option is available for Reporting and Enterprise Matrix?

Ans. No, it's available only for Writeback Matrix (Enterprise Matrix) for On Prem Customers.

2.      Will highest priority run even under high load?

And. Yes, the system must schedule and execute high-priority subscriptions with minimal delay, even under high load. Also, this ensures priority-based execution operates consistently and adheres to the defined priority levels under all scenarios.