Skip to content

n8n: Eth ​

4 active flows.

Summary ​

FlowTriggerCallsProcsTables
Eth Attachment Freshness Check (daily)schedule: cron 0 0 6 * * *001
Eth Attachment Refresh (nightly)schedule: cron 0 0 18,20,21,23,0,2,3,5 * * *010
Eth Catalogue Reporting Refresh (nightly)schedule: cron 0 45 19 * * *013
Eth Estimate Line Catalogue Match Refresh (nightly)schedule: cron 0 5 19 * * *010

Flows ​

Eth Attachment Freshness Check (daily) ​

  • Triggers: schedule: cron 0 0 6 * * *
  • Nodes: 3 · Integrations: SQL
  • Tables/views read or written: EthAttachmentRefreshLog

Eth Attachment Refresh (nightly) ​

  • Triggers: schedule: cron 0 0 18,20,21,23,0,2,3,5 * * *
  • Nodes: 3 · Integrations: SQL
  • Stored procedures: spRefreshEthAttachment

Eth Catalogue Reporting Refresh (nightly) ​

Why this is its own workflow, not a node in Scheduled Report Refresh Its source table dbo.EthEstimateLineCatalogueMatch is rebuilt ONCE a night at 19:05 by Eth Estimate Line Catalogue Match Refresh (nightly). Running this every 3 hours would recompute an ident

  • Triggers: schedule: cron 0 45 19 * * *
  • Nodes: 10 · Integrations: SQL
  • Stored procedures: spRefreshEthCatalogueReporting
  • Tables/views read or written: EthEstimateLineCatalogueMatch, EthCatalogueItemUsage, EthEstimateCatalogueSummary

Eth Estimate Line Catalogue Match Refresh (nightly) ​

  • Triggers: schedule: cron 0 5 19 * * *
  • Nodes: 2 · Integrations: SQL
  • Stored procedures: spRefreshEthEstimateLineCatalogueMatch