Post reply

executing a store procedure in a job step

  • May 6, 2009 at 4:04 pm

    #137356

    I need to execute a stored procedure in a job step.

    Based on the output of the stored procedure, I need to execute the next job step.

    I can get the output in the variable..but how can i control the execution of next job step based on the value in the variable.

    Any ideas??

    Thanks

  • May 6, 2009 at 4:13 pm

    #990048

    Double click on the precedence constraint between the two steps, change the Evaluation operation to expression, and then add your check against the variable in the Expression box.

    John Rowan

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

  • May 6, 2009 at 4:22 pm

    #990054

    I am trying to see in SQL->ServerAgent->Jobs->JobName (Right Click) ->Properties -> then Steps to see the steps.

    I am not able to any precendent contraint where I can define it?>

    if you could help it would be great!!!

  • May 6, 2009 at 4:27 pm

    #990055

    My bad. I though you meant in SSIS. This is an SSIS forum so I assumed your SP was being executed in SSIS. Sorry. I don't think there is a real easy way to do this via SQL Agent.

    John Rowan

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

  • May 6, 2009 at 5:19 pm

    #990066

    yes, You are right..I just start with SSIS for this issue

    Anyways Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

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