USP_DATABASEGROWTHANALYSISPROCESSSCHEDULE_SAVE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SCHEDULETYPECODE	tinyint	IN
@SCHEDULEMONTHLYDAYOFMONTH	tinyint	IN
@SCHEDULEMONTHLYWEEKCODE	tinyint	IN
@SCHEDULEMONTHLYDAYOFWEEKCODE	tinyint	IN
@SCHEDULEDAYOFWEEKCODE	tinyint	IN
@SCHEDULETIME	time	IN

Definition

Copy



create procedure dbo.[USP_DATABASEGROWTHANALYSISPROCESSSCHEDULE_SAVE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SCHEDULETYPECODE tinyint,
  @SCHEDULEMONTHLYDAYOFMONTH tinyint,
  @SCHEDULEMONTHLYWEEKCODE tinyint,
  @SCHEDULEMONTHLYDAYOFWEEKCODE tinyint,
  @SCHEDULEDAYOFWEEKCODE tinyint,
  @SCHEDULETIME time(0)
)
as begin
  set nocount on;

  begin try
    update dbo.[SCHEDULE] set
      [TYPECODE] = @SCHEDULETYPECODE,
      [DAYOFMONTH] = @SCHEDULEMONTHLYDAYOFMONTH,
      [WEEKCODE] = @SCHEDULEMONTHLYWEEKCODE,
      [DAYOFWEEKCODE] = @SCHEDULEMONTHLYDAYOFWEEKCODE,
      [DAYSOFWEEK] = @SCHEDULEDAYOFWEEKCODE,
      [TIME] = @SCHEDULETIME
    from dbo.[SCHEDULE]
    inner join dbo.[BUSINESSPROCESSSCHEDULE] on [BUSINESSPROCESSSCHEDULE].[SCHEDULEID] = [SCHEDULE].[ID]
    inner join dbo.[DATABASEGROWTHANALYSISPROCESS] on [DATABASEGROWTHANALYSISPROCESS].[ID] = [BUSINESSPROCESSSCHEDULE].[BUSINESSPROCESSPARAMETERSETID]
    where [DATABASEGROWTHANALYSISPROCESS].[ID] = @ID;
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;
end