fix(cron): report sqlite path in cron status

Jasmine Zhang · Jasmine Zhang · commit d01bd2c0d7e5 · 2026-06-10T10:17:06.000+08:00
diff --git a/src/cron/service/ops.ts b/src/cron/service/ops.ts
@@ -247,7 +247,7 @@ export async function status(state: CronServiceState) {
     await ensureLoadedForRead(state);
     return {
       enabled: state.deps.cronEnabled,
-      storePath: state.deps.storePath,
+      storePath: state.deps.statusStorePath ?? state.deps.storePath,
       jobs: state.store?.jobs.length ?? 0,
       nextWakeAtMs: state.deps.cronEnabled ? (nextWakeAtMs(state) ?? null) : null,
     };
diff --git a/src/cron/service/state.test.ts b/src/cron/service/state.test.ts
@@ -1,4 +1,5 @@
 import { describe, expect, it, vi } from "vitest";
+import { status } from "./ops.js";
 import { createCronServiceState } from "./state.js";
 
 describe("cron service state seam coverage", () => {
@@ -18,6 +19,7 @@ describe("cron service state seam coverage", () => {
         error: vi.fn(),
       },
       storePath: "/tmp/cron/jobs.json",
+      statusStorePath: "/tmp/state/openclaw.sqlite",
       cronEnabled: true,
       defaultAgentId: "ops",
       sessionStorePath: "/tmp/sessions.json",
@@ -36,6 +38,7 @@ describe("cron service state seam coverage", () => {
     expect(state.storeFileMtimeMs).toBeNull();
 
     expect(state.deps.storePath).toBe("/tmp/cron/jobs.json");
+    expect(state.deps.statusStorePath).toBe("/tmp/state/openclaw.sqlite");
     expect(state.deps.cronEnabled).toBe(true);
     expect(state.deps.defaultAgentId).toBe("ops");
     expect(state.deps.sessionStorePath).toBe("/tmp/sessions.json");
@@ -67,4 +70,24 @@ describe("cron service state seam coverage", () => {
 
     nowSpy.mockRestore();
   });
+
+  it("reports statusStorePath instead of the internal cron mirror path", async () => {
+    const state = createCronServiceState({
+      log: {
+        debug: vi.fn(),
+        info: vi.fn(),
+        warn: vi.fn(),
+        error: vi.fn(),
+      },
+      storePath: "/tmp/cron/jobs.json",
+      statusStorePath: "/tmp/state/openclaw.sqlite",
+      cronEnabled: true,
+      enqueueSystemEvent: vi.fn(),
+      requestHeartbeat: vi.fn(),
+      runIsolatedAgentJob: vi.fn(async () => ({ status: "ok" as const })),
+    });
+
+    const summary = await status(state);
+    expect(summary.storePath).toBe("/tmp/state/openclaw.sqlite");
+  });
 });
diff --git a/src/cron/service/state.ts b/src/cron/service/state.ts
@@ -52,6 +52,8 @@ export type CronServiceDeps = {
   nowMs?: () => number;
   log: Logger;
   storePath: string;
+  /** Optional user-facing storage location reported by cron.status / CLI. */
+  statusStorePath?: string;
   cronEnabled: boolean;
   /** CronConfig for session retention settings. */
   cronConfig?: CronConfig;
diff --git a/src/gateway/server-cron.ts b/src/gateway/server-cron.ts
@@ -42,6 +42,7 @@ import {
 } from "../routing/session-key.js";
 import { defaultRuntime } from "../runtime.js";
 import { parseAgentSessionKey } from "../sessions/session-key-utils.js";
+import { resolveOpenClawStateSqlitePath } from "../state/openclaw-state-db.paths.js";
 import {
   dispatchGatewayCronFinishedNotifications,
   sendGatewayCronFailureAlert,
@@ -307,6 +308,7 @@ export function buildGatewayCronService(params: {
 
   const cron = new CronService({
     storePath,
+    statusStorePath: resolveOpenClawStateSqlitePath(process.env),
     cronEnabled,
     cronConfig: params.cfg.cron,
     defaultAgentId,
diff --git a/src/gateway/server.cron.test.ts b/src/gateway/server.cron.test.ts
@@ -7,6 +7,7 @@ import type WebSocket from "ws";
 import { resetConfigRuntimeState } from "../config/config.js";
 import type { GuardedFetchOptions } from "../infra/net/fetch-guard.js";
 import { peekSystemEvents } from "../infra/system-events.js";
+import { resolveOpenClawStateSqlitePath } from "../state/openclaw-state-db.paths.js";
 import type { GatewayCronState } from "./server-cron.js";
 import {
   connectOk,
@@ -1133,7 +1134,7 @@ describe("gateway server cron", () => {
         | undefined;
       expect(statusPayload?.enabled).toBe(true);
       const storePath = typeof statusPayload?.storePath === "string" ? statusPayload.storePath : "";
-      expect(storePath).toContain("jobs.json");
+      expect(storePath).toBe(resolveOpenClawStateSqlitePath(process.env));
 
       const autoRes = await directCronReq(cronState, "cron.add", {
         name: "auto run test",
