Schedule Forecast: Admin Interface

Version:
Current
Last modified: February 10, 2021

Curators (Gallery admins) can access the schedule forecast that offers the ability to see all schedules in a forward-looking calendar view, and identify potential upcoming bottlenecks of scheduled workflows. As this is a forecast tool, past days are shown as blank.

To access the schedule forecast, go to the Schedule Forecast page in the Gallery Admin interface.

To check details of a specific workflow, select a time slot, then select the desired workflow. You can check the following workflow details: Name and owner of the workflow, if the workflow is recurring or not, its priority, and average runtime. 

Screenshot of the Schedule Forecast section.

Identify Bottlenecks

The schedule forecast uses a heatmap that Gallery admins can use to identify potential upcoming bottlenecks of scheduled workflows. After identifying a bottleneck in the schedule forecast, Gallery admins can take a one-off approach for avoiding bottlenecks by moving jobs to other time slots via the Jobs page. Over time, a Gallery admin might also choose to spin up a new worker to increase the Server throughput capacity and reduce the frequency of scheduling bottlenecks.

You can identify potential upcoming bottlenecks by the color of the time slots. Light blue indicates a bottleneck is unlikely, while dark blue indicates a bottleneck is more likely.

How Is the Heatmap Calculated? 

The schedule forecast calculates a ratio for each 30-minute time slot. The ratio is used to determine the shade of the time slot. To determine the ratio, the total job time capacity and total job time needed are calculated. 

Total Job Time Capacity
First, we need to determine the capacity for a time slot using the number of existing worker nodes and the concurrent workflows multiplied by 30 (minutes). 
Example: We have 1 worker, 2 concurrent workflows at a time. 
Total runtime capacity = 1 x 2 x 30 = 60 minutes 

Total Job Time Needed
Workflows included in the calculation are those scheduled to start in that time slot and any workflows still running from the previous time slot. The predicted workflow runtime beyond the time slot is excluded. 

Ratio
Using these values, a ratio is calculated. Based on this calculation, the time slot is shaded. 
Formula: Total job time needed / Total job time capacity 
The darker shade, the more likely the bottleneck possibility in the time slot.  

Shade for different ratio.

Search and Filter Workflows

To filter schedule by owner, schedule name, workflow name, duration, recurrence, and priority, select the Search icon. Then specify criteria, and select Apply Filter.

Screenshot of the Schedule Forecast section, using Filter.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.