CODEWITHSUNDEEP
sql-serverssmsjobs
Caveman42
Caveman42

Reputation: 709

delete multiple job steps at once in SSMS

I have a job in SSMS with about 129 steps. I am trying to clean it up a bit. Is there a way to delete specified job steps quickly? Instead of going into the job and manually hitting delete on all the steps I need to delete?

Upvotes: 2

Views: 698

Answers (1)

Fedor Kubanets
Fedor Kubanets

Reputation: 21

Delete all corresponding to given job ID or Name

sp_delete_jobstep { [ @job_id = ] job_id | [ @job_name = ] 'job_name' } ,   
     @step_id = 0

Upvotes: 2

Related Questions