USP_EMAIL_PROCESS_SCHEDULE_DISABLE_UPDATE

        CREATE procedure dbo.USP_EMAIL_PROCESS_SCHEDULE_DISABLE_UPDATE
          (
            @CHANGEAGENTID uniqueidentifier,
            @ID uniqueidentifier = null
          )
          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 = @ID
          end