# produce sql reports
20 3 *  * * *   redmine /usr/share/eoredmine/scripts/sqlreports.sh

# every sunday morning, close old tickets with status "deployed" (60 days) or "to deploy" (1 year) - #61270
5 3 * * 0 redmine psql -tA -f /usr/share/eoredmine/scripts/close-old-deployed-tickets.sql -h "pg-intra.entrouvert.org" redmine

# every sunday morning, close support tickets assigned to a client user older than 1 month - #108486
15 3 * * 0 redmine psql -tA -f /usr/share/eoredmine/scripts/close-old-support-tickets.sql -h "pg-intra.entrouvert.org" redmine

# redmine cron/rake jobs
20 3 * * 0 redmine /usr/share/eoredmine/scripts/rake-jobs.sh
