We are doing Data Aging in our environment for CHDR table. We have created the Partitions till 2023 with 1 year as retention.
We have residence period of about 60 days.
As per Data Aging we need to take a restart after the partition job run so that changes will be reflected.
last month we ran the Job via DAGRUN and all the data came into 60 days residence period.
In this case do we need to run every month to keep our residence period 60 days? via DAGRUN. if suppose we did not run the Job what we might face any issue or ?
Thanks and Regards,