sqlmc_list_coverage: Worked exchange
Call 1 — plan.
Call 1 — plan.
{ "name": "sqlmc_list_coverage",
"arguments": { "distributionList": "All Prod",
"workspace": "C:\\repos\\estate\\Estate.smcworkspace" } }
Returns confirmationRequired: true, confirmationToken: "a41f…", targetCount: 12, and four
production targets named. Nothing has been connected to.
Call 2 — scan.
{ "name": "sqlmc_list_coverage",
"arguments": { "distributionList": "All Prod",
"workspace": "C:\\repos\\estate\\Estate.smcworkspace",
"confirmationToken": "a41f…" } }
{
"ok": true, "errors": [],
"listName": "All Prod",
"confirmationRequired": false, "confirmationToken": null,
"targetCount": 12, "alreadyCached": 12,
"productionTargets": [ … ],
"scanned": 12, "failed": 0, "cancelled": false,
"findings": [
{ "schema": "dbo", "name": "CustomerNote", "column": null,
"drift": { "missingFrom": ["sql-prod-09.Sales"], "scanned": 12, "typeVariants": [] } },
{ "schema": "sales", "name": "OrderHeader", "column": "Total",
"drift": { "missingFrom": [], "scanned": 12,
"typeVariants": [
{ "dataType": "decimal(18,2)", "targets": ["sql-prod-01.Sales"] },
{ "dataType": "money", "targets": ["sql-prod-02.Sales"] }
] } }
]
}
If the group changed between the two calls, call 2 returns a new plan with
confirmationRequired: true and a different token, and nothing was read. Do not retry with the old
token; present the new plan.