Desired Outcome

Find out if the job that moves records from the Online tables to the Offline tables is scheduled, enabling the use of statistics queries.

Procedure

In the SFX Admin:

1. Go to Setup & Administration > Administration > Task Manager

2. Check if "Statistics - Handling statistics data > Moving data from Online to Offline tables" is listed.

3. If no online2offline task is scheduled, schedule one by click "Add New Task".

Alternatively, view the scheduled jobs on the SFX server:

1. Log into the SFX server using the relevant instance user
2. View the scheduled jobs, by running:

crontab -l

If there is a cron scheduled, it will appear in the following format:

00 00 * * 00 /exlibris/sfx_ver/sfx4_1/sfxlcl41/admin/stats/online2offline.cron --f --mode=move

The Server Admin Utility can also be used:
1. Log into the SFX server using the relevant instance user

2. Access the Server Admin Util:

server_admin_util

3. Select the following options from the menu:

5 Statistics

Then:

5 Scheduling for statistics maintenance tasks

And:

1 List scheduled tasks for online to offline process

4. If no online2offline task is scheduled, schedule one by selecting:

2 Schedule online to offline process

• Article last edited: 03/29/2016