Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
sfx_routine_maintenance [2019/07/02 13:13]
jmulvaney
sfx_routine_maintenance [2019/07/02 13:16]
jmulvaney [Autoload Instructions]
Line 241: Line 241:
   * Check sample changes on SFX menus.   * Check sample changes on SFX menus.
  
-==== Autoload Instructions ​====+==== Statistics ​==== 
 +The chrons run on the 14th to capture the previous months statistics, although the day of the month has no bearing on the stats. Jack from SFX says “SFX Statistics Queries are run against the '​Offline'​ tables, so the 'Min date' and 'Max date' for the Offline Stats table will give you the current range of available statistics date.” 
 +  * ex. on 20xx-07-02, the Stats saved are for 20xx-06-29 to 20xx-07-01 
 +  * Check the instructions for monitoring the stats table at the [[sfx_update_procedures|Weekly Update]] page 
 + 
 +As of Fall 2018 we run Queries 2,​3,​4,​5,​6,​8,​10,​11,​12 on the 14th of every month, and add in 14 & 19 for Calendar and FY stats. The stats for the calendar and fiscal year should be run as close to the first of the month as possible as there is a moving wall of one year which archives older statistics 
 +  * To manually run the statistics, navigate to the SFX Admin > Queries > and begin selecting queries. 
 +      * Always total by Year 
 +      * When available, choose Top 100 
 +      * #5: Choose all Sources 
 +      * #10: Choose all Targets 
 +      * Change to Specific date range of 1/​1/​20xx-12/​31/​20xx OR 7/​1/​20xx-7/​1/​20xx 
 +      * Leave the defaults for the third row of choices 
 +      * Change format to plain text and delivery to email, and enter the DRMS email 
 +          * Click out of the open text box and then click “Submit Query” 
 + 
 +Click submit query. A second window will open that will cycle for a while and then let you know that the email sent successfully. You can close out this window without affecting the query and move on to the other chrons. You cannot submit a new chron until after the previous results are delivered. 
  
 ==== Support Cases, Content and Enhancement Requests ​ ==== ==== Support Cases, Content and Enhancement Requests ​ ====
sfx_routine_maintenance.txt · Last modified: 2020/11/02 13:51 by jmulvaney
[unknown link type]Back to top
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0