i have 4 folder hierarchy in a following format :
Hourly Daily Weekly Monthly.
In every folder i have files which is coming in a frequency based on their folder's name.
Now , i have to check hourly , daily, weekly and monthly whether latest file has been present in respective folder and if it is then put a mark in my Frequency table that it is present.
For an example , if i have a folder name 'Monthly' and my file is coming on 1 of every month at 5 PM , then the code should check at that particular time only.
As per my research ,this cant be implement through Triggers . Can anyone advice me how should i do this ?