Our DNN+RevIndex setup is integrated with our custom software solution. There is a business process where on certain circumstances new Sales Promotion with XSLT rule is created and inserted into dbo.Revindex_Storefront_SalesPromotion table.
Created rule doesn't work unless we invoke manually Configuration->General->Clear cache. After Clear cache the promotion rule works.
What should we do to 'refresh' Revindex data to apply newly created SalesPromotion?
Is there a way to invoke 'Clear cache' programatically through some API/stored procedure on SQLServer/TaskScheduler?