USP_BUSINESSPROCESSJOBSCHEDULE_UPDATEJOBSTEP

CREATE procedure dbo.USP_BUSINESSPROCESSJOBSCHEDULE_UPDATEJOBSTEP
(
  @JOBID uniqueidentifier,
  @JOBSTEPID int,  
  @COMMAND nvarchar(4000),

  @SCHEDULEID integer = null output
)
as begin
  set nocount on;

  declare @RESULT integer = 0;
  declare @SUCCESS bit = 1;
  declare @PROXY as nvarchar(255) = N'Blackbaud Job Proxy - ' + db_name()

  begin transaction;

  exec @RESULT = msdb.dbo.sp_update_jobstep
                    @job_id = @JOBID,
                    @step_id = @JOBSTEPID,
                    @subsystem = N'PowerShell',
                    @command = @COMMAND,
                    @proxy_name = @PROXY,
                    @database_name = null;

  if @@ERROR <> 0 or @RESULT <> 0 set @SUCCESS = 0;                     

  if @SUCCESS = 1 begin
    commit transaction;
    return 0;
  end else begin
    if @@TRANCOUNT > 0 rollback transaction;
    return 1;
  end                     
end