2 # Regular cron jobs for the db-postgresql package
5 # Daily reporting process
6 25 7 * * * $FFUSER $PHP $FFCRON/reporting_cron.php
8 # Recalculate user popularity metric
9 25 1 * * * $FFUSER $PHP $FFCRON/calculate_user_metric.php
11 # Daily recalculate of the sums under the trove map
12 30 1 * * * $FFUSER $PHP $FFCRON/db_trove_maint.php
14 # Daily deletion of sessions, closing jobs, etc
15 35 1 * * * $FFUSER $PHP $FFCRON/project_cleanup.php
17 # Daily crunching of survey data and other associated ratings
18 40 1 * * * $FFUSER $PHP $FFCRON/rating_stats.php
20 # Daily crunching of project summary data (counts)
21 42 1 * * * $FFUSER $PHP $FFCRON/db_project_sums.php
23 # Daily close pending artifacts
24 43 1 * * * $FFUSER $PHP $FFCRON/check_stale_tracker_items.php
26 # Daily project_weekly_metric recalc
27 12 1 * * * $FFUSER $PHP $FFCRON/project_weekly_metric.php
29 # Daily rotation of the activity_log
30 0 0 * * * $FFUSER $PHP $FFCRON/rotate_activity.php
32 # Daily aggregating of the numbers
33 15 0 * * * $FFUSER $PHP $FFCRON/site_stats.php
35 # Daily sweep of the stats into final tables
36 45 0 * * * $FFUSER $PHP $FFCRON/db_stats_agg.php
38 # Hourly send pending massmailings, if any
39 48 * * * * root $PHP $FFCRON/massmail.php
41 # Weekly db vacuum (should be done after ALL OTHER JOBS)
42 50 2 * * 1 $FFUSER $PHP $FFCRON/vacuum.php
44 # Create SCM repositories
45 0 * * * * root $PHP $FFCRON/create_scm_repos.php
47 # Gather commit stats from SCM repositories
48 0 2 * * * root $PHP $FFCRON/gather_scm_stats.php
50 # Generate snapshots and tarballs from SCM repositories
51 0 3 * * * root $PHP $FFCRON/generate_scm_snapshots.php
53 # this cronjob analyse the apache log and instert them in the db table stats_subd_pages
54 # this is not used in fusionforge IHM.
55 # Daily sweep of the HTTP log files for project activity
56 #15 0 * * * $FFUSER $FFCRON/stats_projects_logparse.pl
58 # this cronjob send a mail to the admin with all news that have been posted less than 30 days and that have not be validated.
59 # Daily mail for not approved news
60 30 17 * * * root $FFCRON/get_news_notapproved.pl