SFX Cron Jobs

Also See:

Job	Time (see note below)	Notes
Google Scholar file	03:30 a.m. on Monday morning	SFX file sent to Google Scholar for UMLinks button access out of GS. Initial registration with GS and setup through ExLibris was required. See SFX documentation. This file was also used (2009-?) by OCLC for eSerials service. OCLC ignored ebooks in file.
Table Maintenance & Repair	02:30 a.m. every month on the second day	Setup by ExLibris to solve a problem pre-2010.
Clean Apache log files	02:17 a.m. on Sunday morning	Cleans log files. Set up by ExLibris.
Elsevier Autoload load	12:01 a.m. the 1st day of the month	Began 2015. Maintained by us. Token can be found in Elsevier Admin under Trusted Partners and lives in the config file in the SFX Admin under Unix File Manager and the “autoloader” tab in the Target Service.
Statistic Queries	6-7:20 a.m. the 14th of the month	As of 2016, runs Queries 2,3,4,5,6,8,10,11,12 and sends reports to DRMS email. Calendar and FY stats are run manually and include Queries 14 & 19. Set up through SFX Admin>Queries and maintained by us.
EDS file transfer	4:01 a.m. on Tuesdays	Sends SFX file to EBSCO to update SFX content information for EDS (not HLM) Possible both the LCL collection for CL and AILC. Began 12/16. HLM is not maintained by this file transfer. Set up by us.
SFX holdings file export	7:00 on the 28th day of the month	SFX holdings file generated and sent Rapid, Browzine and IDS. Rick and Steve B. set this up.
SpringerJournals autoload	12:01 a.m. the 5th day of the month	Began 10/15/18; note correct token in 2nd Springer account. Maintained by us.
SpringerBooks autoload	12:01 a.m. the 6th day of the month	Began 10/15/18. Maintained by us.
OAI Repository Cleanup (bX Stats Deletion)	5:00 a.m. Monday	Began 8/2/19. Deletes all stats from OAI Rep. weekly. Maintained by us.

Notes:

Times are Central time as SFX server is in Chicago.
There are index build jobs run by ExLibris which are not shown here. Best to check with support before adding another job which might conflict with “hidden” ones or with the backup.
SFX Search AZ and RSI indexing is now done centrally by ExLibris and is not shown on our cron list.

Setting up Cron Jobs

For more information see the SFX users guides.
- To set up publisher autoloads: ./server_admin_util > 8 Import/Export > (Choose resource, can set up crons, run autoload, etc.). To edit, use crontab -e
- A list of cron jobs can be found Unix-side: Login>da>crontab -l
- Edit the crontab using “crontab -e” instead.
- Statistics reports crons can be setup via each of the Statistics Queries (sends to email) but old crons need to be removed UNIX side.
- Google Scholar job was setup by registration procedure in the KB, but edited in crontab to add ebook export.
- AZ, RSI and other index jobs also setup via server_admin_util. Can be edited in crontab.
- Example cron: 00 05 03 * * /exlibris/sfx_ver/sfx4_1/umass3/admin/kbtools/marc_enhancement.pl – profile=marcit4export (Note: A cron for MARCIt was not set up due to multiple staff using files that interfered with the running of the cron, and that the cron was only able to replace a small portion of the MARCIt load process. 2016)

SFX Queries

Monthly & Yearly (Calendar & Fiscal) Runs

Query 2: Number of SFX requests and clickthroughs per source – The number of times users clicked the SFX button in any particular source (rec$sourceId) and the number of clickthroughs; output is sorted by source name.
Query 3: Number of SFX requests and clickthroughs sorted by object type – The number of times SFX services were requested and the number of clickthroughs, based on the type of object. Output is sorted by object type. If there is no match between the object in the OpenURL and the SFX database, the Object Type used is genre.
Query 4: Number of SFX requests and clickthroughs per service type – The number of SFX requests and clickthroughs for each service type.
Query 5: Number of SFX requests with/without full‐text services – The number of SFX requests that resulted and did not result in full‐text services in the SFX menu.
Query 6: Top target services shown in the SFX menu – The number of times the most popular targets services appeared in the SFX menu.
Query 8: Number of clickthroughs per target service – The number of times specific target services were selected in the SFX menu.
Query 10: Most popular serials selected by target – The number of times the most frequently requested full‐text journals were shown and selected in the SFX menu from one particular target.
Query 11: Most popular journals selected by source – The number of times the most frequently requested full‐text journals were shown and selected in the SFX menu from a particular source.
Query 12: Journals requested but have no full‐text – The top journals for which SFX requests resulted in no full‐text services in the SFX menu.

Yearly (Calendar & Fiscal Runs)

Query 14: Books accessed via SFX ranked by use – Books (ISBNs) sorted by usage within a specified time period. Output includes ISBN book title, book OBJECT ID, and the number of times accessed. If multiple ISBNs exist for the object, they are all included in the report. If no title or object ID exists, the statistics result include a line with the text No title or No object id.
Query 19: Most popular journals – The number of times the most frequently requested full‐text journals were shown and selected in the SFX menu.

Primary contact: Jack Mulvaney