Cron Jobs

┌───────── minute (0–59)
│ ┌─────── hour (0–23)
│ │ ┌───── day of month (1–31)
│ │ │ ┌─── month (1–12)
│ │ │ │ ┌─ day of week (0–7, 0=Sun)
│ │ │ │ │
* * * * *

// Items CRUD
const svc = await services.items('articles');
await svc.readByQuery({ filter: { status: { _eq: 'draft' } } });
await svc.createOne({ title: 'Auto-generated' });
await svc.updateOne(id, { processed: true });
await svc.deleteOne(id);
 
// Schema services
await services.collections();
await services.fields();
await services.relations();
 
// Files and versions
await services.files();
await services.versions();
 
// Send email
await services.mail({ to: 'user@example.com', subject: 'Report', html: '<p>Done</p>' });
 
// Trigger another cron job
await services.cron.trigger('job-id-or-name');
 
// Whitelisted environment variables
const apiKey = services.env.MY_API_KEY;
 
// Safe HTTP (domain-restricted — configure EXTENSION_ALLOWED_DOMAINS)
const res = await services.fetch('https://api.example.com/data');
 
// Custom services
const notifier = await services.custom('slack-notify');
 
// Raw Supabase (bypasses RLS — use with caution)
const { data } = await services.supabase.from('table').select('*');

// Delete items older than 30 days
const cutoff = new Date();
cutoff.setDate(cutoff.getDate() - 30);
 
const svc = await services.items('daas_activity');
const old = await svc.readByQuery({
  filter: { timestamp: { _lt: cutoff.toISOString() } },
  fields: ['id'],
  limit: 500,
});
 
for (const row of old) {
  await svc.deleteOne(row.id);
}
 
console.log(`Cleaned up ${old.length} old activity records`);