1  -- Migration 047: Add daily HTML DOM cleanup cron job
 2  -- Created: 2026-02-12
 3  -- Description: Adds cron job to clean up html_dom from ignored sites and sites with sent outreaches
 4  
 5  INSERT OR IGNORE INTO cron_jobs (
 6    name,
 7    task_key,
 8    description,
 9    handler_type,
10    handler_value,
11    interval_value,
12    interval_unit,
13    enabled
14  ) VALUES (
15    'HTML DOM Cleanup',
16    'cleanup_html_dom',
17    'Clean up html_dom from ignored sites and sites with sent outreaches to save disk space',
18    'command',
19    'node src/cron/cleanup-html-dom.js',
20    1,            -- Every 1 day
21    'days',
22    1             -- Enabled
23  );