File trigger with many files at once - VisualCron - Forum

Community forum

I have a sql job that runs every minute on the minute to look for files in a specific location. I want to create a job with a file trigger. I know how to handle that but the problem is that there could be many files dumped into the location at one time and i cant have my sql job kicking off for every file. Basically, what i would love to do is have the file trigger wait to kick off a sql job for n seconds so i know all files are there and the job only runs once.
You could add a wait Task in fron of the SQL Task.
Please like  VisualCron on facebook!
Actually what i did is put a condition on the task to look if the job was running, if so then wait x amount seconds to exceute the task if not exeit.
Scroll to Top