USP_EMAIL_PROCESSINGSCHEDULE_DISABLE

Executes the "Email Services Disable All Email Process Schedule Record Operation" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



        create procedure dbo.USP_EMAIL_PROCESSINGSCHEDULE_DISABLE
          (
            @CHANGEAGENTID uniqueidentifier
          )
          as
          begin
            set nocount on;

            update dbo.SCHEDULE set ENABLED = 0
              from dbo.SCHEDULE S
                inner join BUSINESSPROCESSSCHEDULE BPS on BPS.SCHEDULEID = S.ID
                inner join GLOBALCHANGE GC on BPS.BUSINESSPROCESSPARAMETERSETID = GC.ID
                where GC.GLOBALCHANGECATALOGID in ('F79575E5-FE4F-47BD-954C-AB056EF109D9', '5066A489-6282-400C-96AF-1ECC1B7F281F', '8C3ECDB1-BE50-4898-AD1B-98ECB6D07812') 

          end