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