Check accounting periodic procedures

The accounting system runs the accounting procedures below periodically to:

UpdateAccounting processes the data in the accounting master tables to consolidate the resource usage in the accounting_event_detail table.
DeleteOldRegisteredEvents deletes data in the accounting master tables older than the DeleteRegEventsDeleteHours accounting parameter (26280 hours or 3 years by default)

These procedures are configured in the /etc/cron.d/abiquo-accounting cron job. Note that DeleteOldRegisteredEvents does not use its legacy parameter to set the maximum record age by default.

To view the cron job configuration for the accounting procedures, run the command:

cat /etc/cron.d/abiquo-accounting

Here is a sample output from the command

# Runs every hour
0 * * * * root mysql -uroot -hlocalhost -e "CALL kinton.UpdateAccounting();"
# Runs every Sunday at 12:00 and deletes records older than a week.
0 12 * * 0 root mysql -uroot -hlocalhost -e "CALL kinton.DeleteOldRegisteredEvents(168);"