Appearance

n8n: Kpi ​

4 active flows.

Summary ​

FlowTriggerCallsProcsTables
Pre-Calculate Estimator workflowschedule: every undefined010
Pre-Calculate Kpi Active Resultsschedule: every 55 minutes050
Process Kpi Job Queueschedule: every 7 minutes040
Queue Missing Objectsschedule: every 3 hours010

Flows ​

Pre-Calculate Estimator workflow ​

  • Triggers: schedule: every undefined
  • Nodes: 4 · Integrations: SQL
  • Stored procedures: spRefreshEstimatorStageSummary

Pre-Calculate Kpi Active Results ​

  • Triggers: schedule: every 55 minutes
  • Nodes: 9 · Integrations: SQL
  • Stored procedures: spEthKpiResultsActive, spEthKpiResultsActiveAll, spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear

Process Kpi Job Queue ​

Runs the SP that loops through JobId's in the Queue.

  • Triggers: schedule: every 7 minutes
  • Nodes: 8 · Integrations: SQL
  • Stored procedures: spEthProcessKpiQueue, spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear

Queue Missing Objects ​

Find foreign keys that are missing and queue the objects for sync

  • Triggers: schedule: every 3 hours
  • Nodes: 4 · Integrations: SQL
  • Stored procedures: spEthSyncQueueMissingObjects