Marketing statistics considerations

Operational marketing statistics are gathered and stored in the database by the RaiseECEvent scheduled job that is run by the Scheduler at a set interval. By default, this job runs every 5 minutes. To decrease the frequency of this job to reduce any performance impact it might have, we can increase the interval between the jobs.

To change the time interval for the job, run the following SQL statement:

UPDATE SCHCONFIG 
    SET SCCINTERVAL = 1800 
    WHERE SCCPATHINFO = 'RaiseECEvent'

The SCCINTERVAL value defines the length of time, in seconds, before the job is restarted.

If we are using using Management Center for marketing, the time interval value is also configured in the wc-admin-component.xml file for the marketing component. We must update the interval value in that file to match the interval value you specified in the SQL statement. In the wc-admin-component.xml file, look for the following property:

<_config:property name="orderSubmitProcessingFrequency" value="1800"/>

For instructions on updating the wc-admin-component.xml file, see Changing properties in the marketing component configuration file.