Self Driving Enterprise · HVAC EPC · ERP AI

SELF DRIVING ENTERPRISE

HVAC EPC · Project 640

LIVE DATA

ABC LTD 640

FY 2026

OPD BLOCK · PUNE

MR. X / CEO

Process & Data

PROCESS & DATA

Implementation & Transaction Data

Every SQL step from the rollout plan, converted into fields you fill in — no script editor needed.

Day 0 — You set up (≈30 min, once)

These three steps replace the schema script, the DMM bootstrap script, and the sample-campaign inserts. Fill the fields and run each step — no SQL to type.

Run Schema ScriptCreates the core tables the AI engine reads and writes every cycle.

Tables To Create Environment Database

Not run yet — will create AIITEM, AIITEMDET, AIPLANNINGDET, AIPLANNINGID, AIJOBLOG + 14 more tables.

Run DMM Bootstrap ScriptDefines the process, its fields, and the statuses it can move through.

Process Code Process Name Run Cycle Status Set Owner Role Notify Email

Not run yet — this replaces the DMM bootstrap script.

Insert 3 Sample CampaignsEach row below is one AIITEM insert — edit values, add rows, then save.

	Campaign Code	Channel	Campaign Name	Budget (₹)
1
2
3

Not saved yet.

Day 1 — The system runs by itself

Nothing to fill in here — the scheduler fires on its own cycle. Use "Simulate Cycle" to see what a run looks like.

Scheduled Job — usp_RunDMMSQL Server Agent fires this automatically on the cycle you set in Day 0.

Job Name Last Run Next Run

AIJOBLOG — cycle activity

00:00SQL Server Agent fires: EXEC dbo.usp_RunDMM

Day 30 — You add a real campaign

This replaces the AIITEM insert plus the 8 AIITEMDET metric rows. Fill it in once — the next 12-hour cycle picks it up automatically.

New Campaign — AIITEMOne row, same shape as CRM-001…003.

Campaign Code Campaign Name Channel Target Audience Budget (₹) Launch Date

Metric Rows — AIITEMDET8 rows the engine will update every cycle.

	Parameter	Starting Value
1
2
3
4
5
6
7
8

Not saved yet.

Day 60 — Marketing head asks for a new field

This replaces the single AIPLANNINGDET insert. One row, no developer needed — the next cycle records it.

New Field — AIPLANNINGDETAdd a parameter and the formula that computes it.

Applies To Process Parameter Code Data Type

Formula / Description

Equivalent SQL — one row:

INSERT INTO AIPLANNINGDET (AIPLANNINGID, PARAMETER, FORMULA) VALUES (@DMMPlanID, 'WAREPLIES', 'Count of WhatsApp replies')

Custom fields added so far

Process	Parameter	Formula
None yet — add one above.