USP_EMAILSCHEDULE_EDITSAVE

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EMAILTEMPLATEID	int	IN	Email Template ID
@RECURRENCEID	uniqueidentifier	IN	Recurrence ID
@SCHEDULEENABLED	bit	IN	Is Schedule Enabled
@SCHEDULENAME	nvarchar(256)	IN	Schedule Name
@TIMETOQUEUE	time	IN	Time to queue
@LASTRUN	datetime	IN	Last Run
@TIMEZONEID	int	IN	Time Zone ID
@CLIENTUSERSID	int	IN	Client Users ID

Definition

Copy



CREATE procedure USP_EMAILSCHEDULE_EDITSAVE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @EMAILTEMPLATEID integer,
    @RECURRENCEID uniqueidentifier,
    @SCHEDULEENABLED bit,
    @SCHEDULENAME nvarchar(256),
    @TIMETOQUEUE time(0),
    @LASTRUN datetime,
    @TIMEZONEID integer,
    @CLIENTUSERSID integer
)

as
  set nocount on;

    declare @CLIENTSITESID integer;

  exec dbo.USP_EMAILSCHEDULE_EDITLOAD
        @ID = @ID,
        @CLIENTSITESID = @CLIENTSITESID output

  exec dbo.USP_EMAILSCHEDULE_EDITSAVE2
        @ID,
        @CHANGEAGENTID,
        @EMAILTEMPLATEID,
        @RECURRENCEID,
        @SCHEDULEENABLED,
        @SCHEDULENAME,
        @TIMETOQUEUE,
        @LASTRUN,
        @TIMEZONEID,
        @CLIENTUSERSID,
        @CLIENTSITESID

  return 0;