/ db / migrations / 128-citation-monitor-cron.sql
128-citation-monitor-cron.sql
 1  -- Citation Monitor cron job
 2  -- Runs ~/code/mmo-platform/scripts/citation-monitor.sh via claude -p --model opus
 3  -- Searches 25 queries, compares to baseline, creates content to close gaps
 4  
 5  INSERT INTO ops.cron_jobs (
 6    name, task_key, description, handler_type, handler_value,
 7    interval_value, interval_unit, enabled, timeout_seconds
 8  ) VALUES (
 9    'Citation Monitor',
10    'citationMonitor',
11    'AI citation audit for auditandfix.com. Searches 25 queries, compares to baseline, creates content to close gaps, deploys, and commits.',
12    'function',
13    'citationMonitor',
14    14,
15    'days',
16    1,
17    1800
18  ) ON CONFLICT (task_key) DO NOTHING;