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.

---

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.