Periodic Report is a visual builder for DBAs. Write a query, design the email, and get a production-ready T-SQL stored procedure for Database Mail - scheduled with SQL Server Agent. No SSRS, no Power BI, no hand-written sp_send_dbmail.
Runs inside your own SQL Server. MSSQL 2016+ · No agent installed on your data.
Automated report for the previous business day. Regions ordered by revenue.
| Territory | Units | Revenue |
|---|---|---|
| Southwest | 1,432 | $1,284,500 |
| Northwest | 1,190 | $1,041,200 |
| Canada | 884 | $812,940 |
| Central | 640 | $598,300 |
| Southeast | 512 | $471,880 |
| Northeast | 437 | $402,610 |
Generated from a single SELECT - a clean, branded HTML table, ready to email.
SSRS is heavyweight, Power BI needs licenses and a gateway, and hand-writing Database Mail procedures is tedious and error-prone.
Stop copy-pasting sp_send_dbmail boilerplate, HTML tables and CDATA escaping. The builder writes correct, encrypted stored procedures for you.
Everything runs inside the SQL Server you already have. No SSRS server, no Power BI gateway, no third-party agent touching your data.
Professional, responsive HTML templates with your logo and theme colors - instead of a raw grid dumped into an email.
From a single query to a scheduled, branded email - in minutes.
Paste a SELECT, pick a template, set your colors and logo, and watch a live preview as you build.
Generates a complete stored procedure for Database Mail (sp_send_dbmail) - compatible with MSSQL 2016 and later.
One click generates the SQL Server Agent job script: daily, weekly, monthly, last-day-of-month, quarterly - whatever you need.
Build threshold alerts and workflow notifications with dynamic placeholders, each value fetched by its own query.
Reusable recipient groups - type “Sales Team” instead of pasting a dozen addresses into every report.
Six responsive, email-client-tested designs - from minimalist to fully branded with header, logo and accent color.
Generate the stored procedure WITH ENCRYPTION to keep its definition private on your own server.
Generate the Database Mail setup script and verify permissions before you deploy - catch problems early.
A new order has exceeded the alert threshold and requires review.
Values in {{order_id}}, {{customer}} and {{amount}} are pulled live from your database.
Threshold alerts with dynamic values pulled live from your database.
Professional, responsive HTML templates with your logo and theme colors - instead of a raw grid dumped into an email.
No SSRS project, no deployment pipeline. Just SQL.
Paste any SELECT against your SQL Server database. The columns become your report.
Choose a template, set your logo and accent color, and preview the email live.
Get a complete stored procedure for Database Mail. Run it once in your target database.
Generate the SQL Agent job script and pick a cadence. Reports now arrive on their own.
No black box. You get a stored procedure you can read, review and run in your own database.
CREATE OR ALTER PROCEDURE dbo.usp_Report_DailySales
AS
BEGIN
SET NOCOUNT ON;
DECLARE @html NVARCHAR(MAX);
-- Build an HTML table from your query result
SET @html = N'<h1>Daily Sales by Territory</h1>';
SELECT @html = @html + dbo.fn_BuildReportTable(...)
FROM dbo.vw_DailySales;
-- Send it through SQL Server Database Mail
EXEC msdb.dbo.sp_send_dbmail
@profile_name = N'PeriodicReport',
@recipients = N'sales-team@acme.com',
@subject = N'Daily Sales by Territory',
@body = @html,
@body_format = 'HTML';
END;Start free. Upgrade when you need more reports and templates.
For your first few reports
For regular reporting
For teams and agencies
No credit card required to start. Cancel anytime.
Everything a DBA usually asks before trying it.
No. Periodic Report is built specifically for Microsoft SQL Server. It generates T-SQL stored procedures that use Database Mail (sp_send_dbmail) and SQL Server Agent jobs, which are SQL Server features. It supports SQL Server 2016 and later.
No. The builder runs in your browser and generates a T-SQL script. You review it and run it yourself inside your own SQL Server. Your data and credentials never leave your environment.
Through SQL Server Database Mail (sp_send_dbmail), using a Database Mail profile you configure on your server. Periodic Report generates the stored procedure; SQL Server sends the mail via your own SMTP.
Periodic Report generates a SQL Server Agent job script for the cadence you choose - daily, weekly, monthly, last day of month, or quarterly. For SQL Server Express (no Agent), you can export the schedule for an external scheduler.
No. Periodic Report replaces the common “email me this query on a schedule” use case without SSRS, Power BI, a report server or a gateway. Everything runs inside the SQL Server you already have.
A complete, optionally encrypted stored procedure that builds an HTML email from your query result and calls sp_send_dbmail. It is plain T-SQL you can read, review and version-control.
Yes. The Free plan lets you build up to 3 reports with the core templates and full T-SQL generation, so you can deploy a real report before paying anything.
Free to start. Build a report, generate the T-SQL, and have it in your inbox within minutes.
Get started free