Scheduled jobs

// apps/<app>/src/api/overdueReminders.ts
import { z } from 'zod';
import { createEndpoint } from 'zitejs/backend';
import { zite } from 'zitejs/db';
import { ZiteNotifications } from 'zitejs/notifications';

export default createEndpoint({
  description: 'Notify assignees of overdue tickets every weekday at 9am',
  schedule: {
    scheduleType: 'recurring',
    schedule: { frequency: 'weekly', interval: 1, daysOfWeek: ['mon', 'tue', 'wed', 'thu', 'fri'], times: ['09:00'] },
    timezone: 'America/New_York',
  },
  inputSchema: z.object({}),
  outputSchema: z.object({ notified: z.number() }),
  execute: async () => {
    // context.user is null on scheduled fires — don't depend on it here.
    const { rows } = await zite.sql({
      query: `
        SELECT "assigneeId", COUNT(*) AS n
        FROM "Tickets"
        WHERE "status" <> 'closed' AND "dueDate" < CURRENT_DATE
        GROUP BY "assigneeId"
      `,
    });
    for (const r of rows) {
      await ZiteNotifications.create({
        recipients: [String(r.assigneeId)],
        title: `You have ${r.n} overdue tickets`,
        link: { path: '/tickets' },
      });
    }
    return { notified: rows.length };
  },
});

import { ZiteSchedules } from 'zitejs/schedules';

await ZiteSchedules.add({
  endpointId: 'sendReminder',          // typechecked against your real workflows
  schedule: { scheduleType: 'oneTime', fireAt: input.when, timezone: input.tz },
  inputs: { ticketId: input.ticketId }, // must match sendReminder's inputSchema
});