Is there anyway to run by scheduled batch or program that will activate the Reset Cache. We are making changes to Publish Yes, based on Scheduled SQLCMD, (which runs just after midnight triggered by date settings on database) to items and categories, however unless we click Reset Cache, it does not work, we don't want to rely on a person to manually do this on a Sunday night after midnight for a Monday promotion launch.

I know many will say check appconfig on the CacheMenus (currently set to true) and the CachDurationMinutes (currently set to 15), however it does not appear to be triggering a cache reset.

Any suggestions?