Radim.NETRadim Hampel : Microsoft business intelligence, performance management and data warehousingSql script that waits until job is finished- May 7, 2008 In one of my projects I needed to disable certain SQL job from stored procedure and wait until that job is idle. I've been looking around a while and then I quickly build up own code and I hope someone will find it useful - here it is:-- ============================================= -- Author: Radim Hampel -- Create date: 2008-05-06 -- Description: EnablesDisables specified job and waits until it is finished(idle) -- This procedure is used from FullOptimize procedures --...http://blog.vyvojar.cz/radim/archive/2008/05/07/Sql-script-that-waits-until-job-is-finishe... |