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 );