sys.sp_delete_jobstep

Description

Removes a job step from a job in the SQL Server Agent service. The identification number of the job from which the step will be removed. must be specified; both can’t be specified.

Syntax

sp_delete_jobstep
[ [ @job_id = ]
'job_id'
]
[ , [ @job_name = ]
N
'job_name'
]
, [ @step_id = ] step_id
[ ; ]