Job - ProductPrice Cleanup

Personal Library

https://support.intershop.com/kb/29H509

Name	ProductPrice Cleanup
Domain	<Organization>-<Channel>
Job Dependencies	none
AcquiredResources	none
Cartridge	bc_pricing
Pipeline	ProcessProductPriceCleanup-Start
Affected Domain Objects	ProductPriceBO, ProductPriceScaleBO
Affected Tables	Pricelists pricescaleentry pricescaleentry_av pricescaletable pricescaletable_av pricescaletableassignment Jobs jobconfiguration jobconfiguration_av Locking acqlogentry acqlogentryresourceassignment acqlogentry_av isresource isresource_av jobresourceassignment process process_av resourcelock staginggroupresourceassignment
Stored Procedure
Default State	Enabled
Is Site Specific	True
Edit State	Globally Enabled
Live State	Locally Enabled
Description	Removes price list prices older than the configured number of days.
Scheduling	Depends on usage of price lists. The more price lists and price scale tables with specified valid-to dates, the more often the job should be called.
What Happens Switched Off	PriceScaleTable, PriceScaleTable_AV, PriceScaleEntry, PriceScaleEntry_AV, PriceScaleTableAssignment tables grow.
Trouble Shooting	The LifeTime attribute specifies the number of days in the past in which obsolete prices will be searched for.
Comments

Product Version	7.0
Product To Version
Status	New Labels

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.