Scheduled tasks

The store has scheduler jobs that can automatically carry out certain tasks. These are not installed by default and must be set up manually.

Email daily order reports
The purpose of this schedule job is to produce a report every day which is emailed to the store merchant email address.
This report then provides a daily overview of the site orders, also the fact that the report is sent daily ensures the store email functionaity is working. This task saves the last runtime in the store setting, and will only run the report once a day, even if this is set to one hour.

The report is produced using XSL the path of the "ordersreport_<Culture>.xsl" which is uploaded into the module directory when it is installed, must be entered in the store settings. This defaults to the module directory, but is modifiable so different portals can have different reports.

NEvoWeb.Modules.NB_Store.StoreOrderReport,NEvoweb.DNN.Modules.NB_Store
Time Lapse: 1 hour*
Retry Frequency: 2 hours



Purge old carts and orders
This schedule job will delete carts from the database that are older than 7 days and removed uncompleted orders that are older that 24 hours.

NEvoWeb.Modules.NB_Store.CleanUpCarts,NEvoweb.DNN.Modules.NB_Store
Time Lapse: 1 day
Retry Frequency: 2 days

SPROC:NEvowebNBStoreCartDeleteOldCarts
delete from dbo.NB_Store_Cart
where DateCreated < dateadd(day,-7,getdate())
delete from dbo.NB_Store_Orders
where OrderDate < dateadd(day,-1,getdate())
and OrderNumber = ''



Calculate Discounts
The purpose of this schedule job is to recalculated the discount prices for all the products and is only needed if promotional Store Discounts have been setup for the store. This task saves the last runtime in the store setting, and will only run the calculation once a day, even if this is set to one hour.

NEvoWeb.Modules.NB_Store.CreateSalePrices,NEvoweb.DNN.Modules.NB_Store
Time Lapse: 1 hour
Retry Frequency: 2 hours



Run scheduled reports
The purpose of this schedule job is to run any reports that have been schduled from the reporting system. The functionality to time reports to an hours has been implemented. Best results require that your DNN instance run the scheduler in Timer mode, especially if it is a low-traffic server that regularly unloads the application.

NEvoWeb.Modules.NB_Store.SchedulerReport,NEvoweb.DNN.Modules.NB_Store

Time Lapse: 1 hour
Retry Frequency: 2 hours



Run search word statistics and product count
The purpose of this schedule job is to purge the statics from the NB_Store Database and to Process and statistical calculations that are required. This job saves the last runtime in the store setting, and will only run the report once a day.

NEvoWeb.Modules.NB_Store.StoreStatistics,NEvoweb.DNN.Modules.NB_Store

Time Lapse: 1 hour*
Retry Frequency: 2 hours


Remove old log files, temporary image files and orhpaned documents and images
This optional task keeps portal folders clear of unnecessary files. There is a Back Office setting called purgelogfiles.days which indicates the number of days worth of log files to keep - suggest 3 months or so. This setting does not affect removal of other items, and these will be purged at every cycle.

NEvoWeb.Modules.NB_Store.PurgeStoreFiles,NEvoweb.DNN.Modules.NB_Store

Time Lapse: 1 Day
Retry Frequency: 1 hours

 

Last edited Oct 17, 2013 at 8:33 AM by leedavi, version 5

Comments

robax Jun 28, 2012 at 3:06 PM 
The store documentation purposefully does not cover any information or operation that is already part of core DotNetNuke documenation.

angelitasr Feb 24, 2011 at 4:33 AM 
This documentation should clarify that the Scheduled jobs are added inside DNN (Host->Schedule)