USP_BUSINESSPROCESSJOBSCHEDULE_USERMAPPING_EDIT

create procedure dbo.[USP_BUSINESSPROCESSJOBSCHEDULE_USERMAPPING_EDIT]
(
  @BUSINESSPROCESSPARAMETERID uniqueidentifier,
  @JOBSCHEDULEID int,
  @APPUSERID uniqueidentifier
)
as begin
  set nocount on;

  declare @CHANGEAGENTID uniqueidentifier
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

   begin try

     update dbo.BUSINESSPROCESSJOBSCHEDULEUSERMAPPING
      set APPUSERID = @APPUSERID,
          DATECHANGED = @CURRENTDATE,
          CHANGEDBYID = @CHANGEAGENTID
     where JOBSCHEDULEID = @JOBSCHEDULEID
     and BUSINESSPROCESSPARAMETERID = @BUSINESSPROCESSPARAMETERID

  end try
  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

end