Hi there
We have been running the Advanced ETP processor (Enterprise version) gat a site for several months successfully.
However, there is a step- in the package that executes a MS SQL stored procedure to perform a search and replace in a database.
The package runs overnight at a time when there is no other database activity, but there have been a couple of times where some other database activity has been started and it can cause the search and replace procedure to hang and soak up server resources for the following day.
I have searched though the documentation to see if there is any option of defining a maximum execution time for a package step or the complete package to finish. If the execution time goes over the defined maximum execution time the package run would be aborted.
Does AETL contain any such facility that can enable a maximum run time to be set and if exceeded, cause the package execution to be aborted?
The SQL environment is MS SQL 2005 – I have found there is a query option facility to set a maximum time for a query but there does not appear to be a facility to apply the same approach top executing a procedure
Thank you for your assistance
Regards,
Andrew
