Post reply

How to comment out the step in the sql job

  • August 1, 2009 at 10:43 am

    #212771

    Does anyone knows how to comment out the step in sql job,

    so that I can rerun the job again without executing the step,

    to get rid of the error, and give me time to debug the issue.

    I don't want to disable the job though.

    any idea would be appreciated.

  • August 1, 2009 at 12:30 pm

    #1033374

    You can't comment out the step but you can comment out the code it runs. Use whatever constitutes a comment or rem for whatever type of code the block is running. Either that or just short circuit the code with an early exit or return.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • August 1, 2009 at 12:47 pm

    #1033379

    Hi Jeff, how are you? Long time no talk (actually I have not posted anything here for a while until today).

    Thanks for responding to my post. That's too bad. I was hoping that I can just comment out the step

    instead of the code itself. But I appreciate a lot for taking the time to answer my question.

    have a wonderful Saturday.

  • August 1, 2009 at 1:27 pm

    #1033390

    I'm doing great. Thanks for asking.

    You also told me that I should write books on SQL way back then. I'm actually in the process of writing one. I'm way behind on it, but I'm writing one.

    Thanks for the feedback, SQLBlue. Looking forward to when next we meet.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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