Send weekly SQL Server health reports via email
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (every day at 07:00). Along the way it connects Microsoft SQL.
How it runs
Trigger: On a schedule (every day at 07:00).
- top slow queries (Microsoft SQL): run a query
- blocking & wait stats (Microsoft SQL): run a query
- index fragmentation (Microsoft SQL): run a query
- missing indexes (Microsoft SQL): run a query
- Merge: merges the data from its input branches
- Code: runs custom JavaScript code
- Send Email: sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft SQL
n8n-nodes-base.microsoftSql - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend
From the author
Description This workflow runs every Monday morning and automatically diagnoses the health of your SQL Server database across 4 dimensions — slow queries, missing indexes, index fragmentation, and server wait stats. It merges all results, scores each finding…