Scheduling the DownloadStatistics job to copy marketing and search statistics
Marketing and search statistics must be available on the staging server so that
business users can view up-to-date data in statistics reports and search rule experiments in
Management Center. You can create and schedule a DownloadStatistics job on the staging or authoring
server to connect to and automatically copy search and marketing event statistics from the
production server at a scheduled interval, for example, every ten minutes. The
DownloadStatistics job connects to the production server by using the quick publish database
connection to keep the search statistics up-to-date on the staging or authoring server.
Procedure
- Open the Administration Console and select Site on the Administration Console Site/Store Selection page.
- Click . A list of jobs that are scheduled to run is displayed.
-
Create the DownloadStatistics job:
Results
Your job is listed on the Scheduler Status Display page and runs at the specified start time.
What to do next
After you create the DownloadStatistics job, you can configure it using the configuration found in the xml/config/com.ibm.commmerce.infrastructure/wc-component.xml file.
The table names to be downloaded must be listed as properties under
For
example:
DownloadStatistics-Configurations
:Property name | Property value |
---|---|
Reference name (not used internally by the runtime) | Defines the configuration grouping name that is used for a database table |
<_config:configgrouping name="DownloadStatistics-Configurations">
<_config:property name="SearchStatistics" value="DownloadStatistics-SRCHSTAT"/>
</_config:configgrouping>
For each of the database table configuration grouping sections, the following properties can be used:
- TableName
- The name of the database table to be downloaded.
- Mode
- Download mode:
copy
(default), ormove
. - BatchSize
- The maximum number of records to be processed all at once in a single batch unit of work.
- Threshold
- The maximum threshold limit of records to be processed.
<_config:configgrouping name="DownloadStatistics-SRCHSTAT">
<_config:property name="TableName" value="SRCHSTAT"/>
<_config:property name="Mode" value="move"/>
</_config:configgrouping>