1  -- Migration 046: Add weekly learning report cron job
 2  -- Date: 2026-02-11
 3  -- Purpose: Add automated weekly analysis of prompt feedback patterns
 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      '10.1 Weekly Learning Report',
16      'weeklyLearningReport',
17      'Analyze prompt feedback patterns and flag low-performing prompts (<70% approval) for human review',
18      'command',
19      'node src/cron/weekly-learning-report.js',
20      7,
21      'days',
22      1
23  );