/ db / migrations / 107-add-cleanup-logs-cron.sql
107-add-cleanup-logs-cron.sql
 1  -- Register the cleanup_logs daily cron job
 2  -- Purges old rows from pipeline_metrics, cron_job_logs, and agent_logs
 3  INSERT OR IGNORE INTO cron_jobs (
 4    task_key, name, description, handler_type, handler_value,
 5    interval_value, interval_unit, enabled
 6  ) VALUES (
 7    'cleanup_logs',
 8    '9.9 Cleanup DB Logs',
 9    'Purge old rows: pipeline_metrics (7d), cron_job_logs full_log (7d) / metadata (90d), agent_logs (7d)',
10    'command',
11    'node src/cron/cleanup-logs.js',
12    1,
13    'days',
14    1
15  );