I have not had to do time based alerting before so I want to see if I have this correct.
I have a file monitor setup to check a folder on a server for the existence of an XLS file and a corresponding alert setup to send out an email if a file is not found. This works great and I thought we had this working until we met with the app owners.
Here is what happens on their end. File is generated at 20 mins past the hour and sometimes it takes 15-20 mins for the file to get generated and placed in the folder.
Right now alerts have been going out around 30 mins into the hour but then clears with 5-10 mins when the file is placed.
I need to figure out if I can have the alert fire off probably at the top of the hour or maybe the last 20 mins of the hour so they can check.
Right now I setup under Properties to Evaluate the trigger condition every 1 hour. Not sure if this is the correct way to do this or if I should do it in the Trigger condition.
Thanks! -Dave