We receive a file from a client at 10pm every night. We want to delay execution of the job that processes these files until 5am the next day (7 hours).
There are two ways we've tried to accomplish this, and both of them have drawbacks we want to avoid:
1. If we use a file trigger, the job will trigger and run at 10pm. If we want to delay until 5am, we would need to set a Wait task for 7 hours. This isn't ideal because if, for example, the server is rebooted at any time during those 7 hours, the job stops and the processing tasks will not run.
2. If we use a time trigger, the job will run on all files that exist in the folder at the specified time. Rarely, the client will drop two files, and since our process expects only one file, the job fails.
I don't believe time exceptions are what I'm looking for because, from my understanding, they will cause the job to simply not run when the job is triggered.
I have considered having both a time and a file trigger and using a dependency to evaluate the triggers together, but I'm not 100% sure how to set that up correctly.
Edited by user
2021-04-21T20:20:45Z
|
Reason: Not specified