What is the best approach to Automate a sqlagent Job

  • 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

  • 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

  • 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