File trigger with many files at once - VisualCron - Forum

Community forum

klewis10367
2009-09-15T19:32:35Z
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.
Support
2009-09-18T19:39:43Z
You could add a wait Task in fron of the SQL Task.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
klewis10367
2009-09-18T19:51:30Z
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