• At the end of this thread you can find the code to detect if a job is running or not and all you will have to code after that is someting like

    exec sp_startJob ...

    DECLARE

     @job_name sysname,

     @status tinyint

    WHILE 1=1

    begin

    EXEC DBA..af_Job_Status 'YourJobName', @Status OUTPUT

    IF @Status <> 0 --Not Done

      Wait for '00:00:01' --1s

    ELSE

      Break

    end

    another option is to fire the next job at the end of the previous one and create like a job chain. It is not pretty but you don't have to code... your choice

    hth

     

     


    * Noel