USP_BUSINESSPROCESSJOBSCHEDULECONVERSION_LOGERROR

Parameters

Parameter	Parameter Type	Mode
@BUSINESSPROCESSNAME	nvarchar(255)	IN
@JOBNAME	nvarchar(255)	IN
@EXCEPTION	nvarchar(255)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_BUSINESSPROCESSJOBSCHEDULECONVERSION_LOGERROR
(@BUSINESSPROCESSNAME nvarchar(255),
 @JOBNAME nvarchar(255),
 @EXCEPTION nvarchar(255),
 @CHANGEAGENTID uniqueidentifier = null)
        as
        set nocount on;

    declare @CURRENTDATE datetime;

        if @CHANGEAGENTID is null
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        set @CURRENTDATE = GetDate();

    insert into dbo.BUSINESSPROCESSJOBSCHEDULECONVERSIONEXCEPTION (BUSINESSPROCESSNAME,
      JOBNAME,
      EXCEPTION,
      ADDEDBYID,
          CHANGEDBYID,
          DATEADDED,            
      DATECHANGED)
    values(@BUSINESSPROCESSNAME,
      @JOBNAME,
      @EXCEPTION,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE);