JRC recache scripts \

/*
truncate table shared.dbo.cachestorage_JRC_BM
update shared.dbo.CacheStorage_JRC_BM_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_DC
update shared.dbo.CacheStorage_JRC_DC_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_DF
update shared.dbo.CacheStorage_JRC_DF_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_DL
update shared.dbo.CacheStorage_JRC_DL_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_DT
update shared.dbo.CacheStorage_JRC_DT_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_HR
update shared.dbo.CacheStorage_JRC_HR_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_JR
update shared.dbo.CacheStorage_JRC_JR_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_MD
update shared.dbo.CacheStorage_JRC_MD_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_MI
update shared.dbo.CacheStorage_JRC_MI_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_MJ
update shared.dbo.CacheStorage_JRC_MJ_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_MP
update shared.dbo.CacheStorage_JRC_MP_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_MS
update shared.dbo.CacheStorage_JRC_MS_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_NH
update shared.dbo.CacheStorage_JRC_NH_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_OD
update shared.dbo.CacheStorage_JRC_OD_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_OP
update shared.dbo.CacheStorage_JRC_OP_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_PV
update shared.dbo.CacheStorage_JRC_PV_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_RC
update shared.dbo.CacheStorage_JRC_RC_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_RO
update shared.dbo.CacheStorage_JRC_RO_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_SC
update shared.dbo.CacheStorage_JRC_SC_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_ST
update shared.dbo.CacheStorage_JRC_ST_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_TR
update shared.dbo.CacheStorage_JRC_TR_permanent set [Timestamp] = DATEADD(d, -30, getdate())

truncate table shared.dbo.cachestorage_JRC_TT
update shared.dbo.CacheStorage_JRC_TT_permanent set [Timestamp] = DATEADD(d, -30, getdate())
truncate table shared.dbo.cachestorage_JRC_WW
update shared.dbo.CacheStorage_JRC_WW_permanent set [Timestamp] = DATEADD(d, -30, getdate())
*/