Page 1 of 1

Question about ADMIN_archive_log_tables.pl script

PostPosted: Wed Jun 29, 2022 10:31 am
by dhijrwn
### roll logs monthly on high-volume dialing systems
#30 1 1 * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl --months=6

### roll call_log and vicidial_log_extended daily on very high-volume dialing systems
#20 1 * * * /usr/share/astguiclient/ADMIN_archive_log_tables.pl --daily

Hi guys I have a question about these 2 entries in the crontab, currently it is commented but when I tried to run these script it just only inserted the current data to their archive log per table.
Is is ok to add these flags --wipe-all-being-archived --wipe-closer-log so after they are inserted, they will be deleted automatically on the live tables?

Re: Question about ADMIN_archive_log_tables.pl script

PostPosted: Wed Jun 29, 2022 4:13 pm
by carpenox
yes sir, thats why they are available options, you can see them all by just adding help to your /usr/share/astguiclient/ADMIN_archive_log_tables.pl --help

Re: Question about ADMIN_archive_log_tables.pl script

PostPosted: Wed Jun 29, 2022 4:31 pm
by dhijrwn
carpenox wrote:yes sir, thats why they are available options, you can see them all by just adding help to your /usr/share/astguiclient/ADMIN_archive_log_tables.pl --help


Thank you. Can I enable them both? Daily and monthly?

Re: Question about ADMIN_archive_log_tables.pl script

PostPosted: Thu Jun 30, 2022 8:43 am
by carpenox
yes on separate crontab lines

Re: Question about ADMIN_archive_log_tables.pl script

PostPosted: Fri Jul 01, 2022 3:44 pm
by williamconley
Basically the --daily is for cleaning out logs that really don't have any reports based on them, they are primarily for troubleshooting. So running that as an option can be considered a completely separate feature compared to archiving the rest of the logs.

Re: Question about ADMIN_archive_log_tables.pl script

PostPosted: Sat Jul 02, 2022 8:58 am
by dhijrwn
I see, activating that in crontab will help the database reduce records, Thank you for your answers.