Set time limit for a recurring sql job RRS feed

  • Question

  • Hi,

    I have an sql job that runs on a daily basis(recurring) and executes a ssis package.This ssis package starts with a file watcher control that keeps looking for a particular file to be generated, and once the file is found begins the execution of the package.However incase the the file watcher spends more than 8 hrs waiting for the file to be generated, i want the sql job to stop executing the package and exit. The file watcher control doesnt allow me to set such a time limit. So i want to know if it is possible to limit the sql job form executing beyond a specific time.


    Wednesday, February 17, 2010 5:34 AM


All replies