Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
sfx_statistics_archives_files [2018/12/18 13:41] cknapp |
sfx_statistics_archives_files [2018/12/19 12:11] cknapp |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== SFX Statistics and Archives Files ====== | ====== SFX Statistics and Archives Files ====== | ||
| - | **As of 12/2017**, SFX statistics will be automatically archived each month, leaving 12 months in the file for running year and FY stats. Archived files may be retrieved through server_admin_util -> 5 -> 3. | ||
| - | **As of 2016** we are running SFX Queries 2,3,4,5,6,8,10,11,12 by cron monthly, plus 14 and 19 for calendar and fiscal year stats. RUN TOP 100 ONLY for queries 2,10,11,12, 14,19. | + | Except for fiscal and calendar year reports, SFX statistic queries are set up as cron jobs, running on the 14th of the following month, 6:00-7:15 a.m. Central/Chicago time. Crons send files to DRMS email or files can be found in SFX Admin>UNIX File Manager>dbs/scratch. Statistics reports crons can be rescheduled through SFX Admin>Statistics>Queries>(Query#)>Schedule. Crons can be removed UNIX side (da>"crontab -l" to list jobs, "crontab -e" to edit). SFX statistics are automatically archived by ExLibris each month, leaving 12 months in the file for running year and FY stats. Archived files may be retrieved through server_admin_util -> 5 -> 3. To avoid re-instating archived files, do fiscal and calendar stats soon after January and July 1. |
| - | Except for fiscal and calendar year reports, SFX statistic queries are set up as cron jobs, running on the 14th of the following month, 6:00-7:15 a.m. Central/Chicago time, sending files to DRMS (or an individual) email. Statistics reports can be rescheduled through SFX Admin>Statistics>Queries>(Query#)>Schedule. Previously scheduled reports need to be removed UNIX side (da>"crontab -l" to list jobs, -e to edit). | + | MONTHLY AND YEARLY: SFX Queries 2,3,4,5,6,8,10,11,12 are run by cron monthly, adding 14 and 19 for calendar and fiscal year stats. Calendar and fiscal year stats are done manually. **RUN TOP 100 ONLY** for queries 2,10,11,12,14,19. Stat reports are manually opened from email file, checked, and stored at Q:/DRMS/SFX/SFX_statistics. |
| - | Stat reports are manually opened from email, checked, and stored at Q:\SFX\SFX_statistics. | ||
| Here is a historical list of statistics files when we archived manually. | Here is a historical list of statistics files when we archived manually. | ||
