# Crontab entry for Strategist AI Analytics Refresh.
# This job runs every 15 minutes and refreshes analytics/dbt models for all eligible tenants.

# Installation:
# 1. Open your crontab: crontab -e
# 2. Paste the following lines, adjusting PROJECT_DIR if necessary:
PROJECT_DIR="/var/www/html/strategist-ai"
*/15 * * * * mkdir -p "$PROJECT_DIR/scripts/logs" && cd "$PROJECT_DIR" && DBT_EXECUTABLE="$PROJECT_DIR/venv/bin/dbt" "$PROJECT_DIR/venv/bin/python3" scripts/cron_analytics_refresh.py >> "$PROJECT_DIR/scripts/logs/cron_stdout.log" 2>&1

# Note: The script maintains its own detailed logs in scripts/logs/analytics_refresh.log