Cron Job

// apps/azalt/src/server/db/types/cron-job.ts (simplified)
interface CronJob {
  id: string;
  name: string;
  description: string | null;
  code: string;                    // JavaScript code to execute
  schedule: CronJobSchedule;       // Execution frequency
  isActive: boolean;               // Enable/disable execution
  organizationId: string;
  createdById: string;
  lastExecutionAt: Date | null;    // Last run timestamp
  nextExecutionAt: Date | null;    // Next scheduled run
  metadata: JsonValue | null;      // Custom metadata
}

type CronJobSchedule =
  | "5m"   // Every 5 minutes
  | "10m"  // Every 10 minutes
  | "15m"  // Every 15 minutes
  | "30m"  // Every 30 minutes
  | "1h"   // Every hour
  | "2h"   // Every 2 hours
  | "4h"   // Every 4 hours
  | "6h"   // Every 6 hours
  | "12h"  // Every 12 hours
  | "1d"   // Daily
  | "1w";  // Weekly

// Sync data from external API
const response = await fetch('https://api.example.com/data', {
  headers: { 'Authorization': `Bearer ${secrets.API_KEY}` }
});

const data = await response.json();
console.log(`Fetched ${data.items.length} items`);

// Process and store data
for (const item of data.items) {
  await db.insertInto('CustomTable')
    .values({ externalId: item.id, value: item.value })
    .execute();
}

// Send notification
await email.send({
  to: env.ADMIN_EMAIL,
  subject: 'Data Sync Complete',
  body: `Synced ${data.items.length} items successfully.`
});

return { synced: data.items.length };