December 8, 2016 at 9:30 am
Hello All
I have to automate a sql agent job, when the source file arrives in a different server, what is the best
approach to implement this - Script Task/Foreachloop, i dont want to use.
Which one is good among WMI Event Watcher Task/ Windows service? I am not able configure different server
path in WMI Event Watcher Task.
Thanks
December 8, 2016 at 9:35 am
Run the job every five minutes, say, and have it check whether the file exists. If it does, proceed to the part of the job that does the processing.
John
December 8, 2016 at 10:25 am
The general approach we use is to have some kind of script that will check for your file and wait a certain amount of time for a file with a certain age on it and either return success or failure. I've done that in vbs and powershell called from the command line but there are plenty of options available out there.
In general I'd try avoid an indefinite wait or a job that just checks for a file then exits with no error if nothing is there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply