How to comment out the step in the sql job

Question

How to comment out the step in the sql job

sqlblue

SSCrazy

Points: 2324
More actions
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.
November 19, 2024 at 9:14 am

This was removed by the editor as SPAM

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

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

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 1

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)

sqlblue SSCrazy Points: 2324 More actions · Answer 2

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.

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 3

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)