USP_BUSINESSPROCESSJOBSCHEDULE_USERMAPPING_ADD

create procedure dbo.[USP_BUSINESSPROCESSJOBSCHEDULE_USERMAPPING_ADD]
(
  @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
    insert into dbo.BUSINESSPROCESSJOBSCHEDULEUSERMAPPING
        (ID, 
       BUSINESSPROCESSPARAMETERID, 
       JOBSCHEDULEID, 
       APPUSERID,
       ADDEDBYID, 
       CHANGEDBYID, 
       DATEADDED, 
       DATECHANGED)
      values
        (newid(), 
       @BUSINESSPROCESSPARAMETERID, 
       @JOBSCHEDULEID, 
       @APPUSERID,
       @CHANGEAGENTID, 
       @CHANGEAGENTID, 
       @CURRENTDATE, 
       @CURRENTDATE)
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

end