jobs.sp_delete_jobstep (Azure Elastic Jobs) (Transact-SQL)
Applies to: 
Azure SQL Database
Removes an existing job step from an existing job in the Azure Elastic Jobs service for Azure SQL Database.
This stored procedure shares the name of sp_delete_jobstep with a similar object in SQL Server for the SQL Server Agent service. For information about the SQL Server Agent version, see sp_delete_jobstep.
Transact-SQL syntax conventions
Syntax
[jobs].sp_delete_jobstep [ @job_name = ] 'job_name'
[ , [ @step_id = ] step_id ]
[ , [ @step_name = ] 'step_name' ]
[ , [ @job_version = ] job_version OUTPUT ]
Arguments
@job_name
The name of the job from which to remove the step. job_name is nvarchar(128), with no default.
@step_id
The identification number for the job step to be deleted. Either step_id or step_name must be specified. step_id is an int.
@step_name
The name of the step to be deleted. Either step_id or step_name must be specified. step_name is nvarchar(128).
@job_version OUTPUT
Output parameter assigned the new job version number. job_version is int.
Return code values
0 (success) or 1 (failure).
Remarks
To remove an entire job, use jobs.sp_delete_job (Azure Elastic Jobs).
Any in-progress executions of the job aren't affected.
The other job steps are automatically renumbered to fill the gap left by the deleted job step.
Permissions
By default, members of the sysadmin fixed server role can execute this stored procedure. Only members of sysadmin can use this stored procedure to edit the attributes of jobs that are owned by other users.