USP_EMAIL_PROCESS_SCHEDULE_DISABLE

  CREATE procedure dbo.USP_EMAIL_PROCESS_SCHEDULE_DISABLE
          (
            @GENERALPURPOSEID uniqueidentifier = null,
            @TRANSACTIONALID uniqueidentifier = null,
            @STATUSPROCESSID 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 IN(@TRANSACTIONALID, @GENERALPURPOSEID, @STATUSPROCESSID)
          end