Post reply

evaluating vars in a loop

  • March 25, 2010 at 3:50 am

    #231128

    Hi,

    Can someone please help me. I'm trying to evaluate a variable in a loop.

    The variable contains the outcome of an sqltask which checks if a job has stopped running The Sql Task is inside the Loop container.

    I have 2 variables:

    Loop

    JobStatCheck

    The SqlTask JobStatus is inside the for Loop container and returns @JobStatCheck = 1 when the job has finished.

    Initexpression: @Loop = @JobStatCheck

    Eval Expression: @Loop > 0

    AssignExpression: I left empty

  • March 25, 2010 at 3:29 pm

    #1140031

    Do you have a specific question? How is your loop not meeting your needs? Are you getting errors?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 26, 2010 at 2:11 am

    #1140178

    The loop keeps running even though the variable changes, when the job has ended. Im also trying to find the watcher so i can review the value of the vars.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply