Subject: Install Hourly HubSpot Sync Cron Job Hi [Hosting Provider / Server Admin], I need to install a cron job on the production server to run a HubSpot sync script hourly. CRON ENTRY TO ADD: ------------------ 0 * * * * cd /var/www/lexikon && /usr/bin/php v2/cron/sync-affiliate-hubspot.php >> /var/log/affiliate-sync.log 2>&1 SCHEDULE: --------- Runs hourly at minute 0 (00:00, 01:00, 02:00, etc.) WHAT IT DOES: ------------- - Syncs affiliate partner data from HubSpot - Updates partner levels and MRR calculations - Caches data locally for dashboard display INSTALLATION OPTIONS: -------------------- Option 1 (Recommended - if you have SSH access): cd /var/www/lexikon crontab v2/cron/crontab-production.txt Option 2 (Manual - add to existing crontab): crontab -e # Add the cron entry above Option 3 (cPanel/Plesk): - Use the Cron Jobs interface - Schedule: Hourly (or 0 * * * *) - Command: cd /var/www/lexikon && /usr/bin/php v2/cron/sync-affiliate-hubspot.php >> /var/log/affiliate-sync.log 2>&1 PATH NOTES: ----------- - Update /var/www/lexikon if your production directory is different - Update /usr/bin/php if PHP CLI is in a different location (find with: which php) VERIFICATION: ------------- After installation, please run: php v2/scripts/affiliate/verify-cron-installed.php Or check manually: crontab -l | grep sync-affiliate-hubspot LOG FILE: --------- Sync output will be logged to: /var/log/affiliate-sync.log Thank you!