Post reply

Change name of a particular step in an existing SQL Agent Job

  • December 24, 2020 at 5:10 am

    #3823722

    What is the easiest way to change name of a particular step in an Agent Job?

    SSMS does not seem to allow to do that.

     

    Likes to play Chess

  • December 24, 2020 at 7:26 am

    #3823735

    You can use sp_update_jobstep.  Are you sure you can't do it in SSMS?  If you open the properties tab of the step in question you can edit the Step Name.

     

    • This reply was modified 3 years, 11 months ago by  Neil Burton.
    • This reply was modified 3 years, 11 months ago by  Neil Burton.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • January 5, 2021 at 2:24 pm

    #3827605

    What are you seeing when you try to make the update? Is the step name greyed out and read-only or do you get an error? The first is probably permissions related. If you get an error, please post this.

    Attach a screenshot as this may help resolve your question.

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

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