/ db / migrations / 114-autoresponder-cron-job.sql
114-autoresponder-cron-job.sql
 1  -- Migration 114: Register autoresponder cron job
 2  --
 3  -- Context: LLM-powered auto-reply to inbound SMS/email messages using Claude Opus.
 4  -- Runs every 5 minutes as a function-type cron job (calls runAutoresponder() handler).
 5  -- Enabled by default; kill switch is AUTORESPONDER_ENABLED=false in .env.
 6  -- handler_type='function' means cron.js calls HANDLERS['autoresponder']() directly.
 7  
 8  INSERT OR IGNORE INTO cron_jobs (
 9      name, task_key, description,
10      handler_type, handler_value,
11      interval_value, interval_unit,
12      enabled, critical, timeout_seconds
13  ) VALUES (
14      'Autoresponder',
15      'autoresponder',
16      'LLM-powered auto-reply to inbound SMS/email messages using Claude Opus. Follows reply funnel: interested -> free fix, confused -> intro+fix, pricing -> price+link, hostile/STOP -> skip.',
17      'function',
18      'autoresponder',
19      5,
20      'minutes',
21      1,
22      0,
23      120
24  );