USP_SIMPLEDATALIST_EMAILPROCESSES

List of current General Purpose and Transactional Email Jobs

Definition

Copy

        CREATE procedure dbo.USP_SIMPLEDATALIST_EMAILPROCESSES
        as
        begin
          set nocount on;
          select
                        [VALUE] = '00000000-0000-0000-0000-000000000001',
                        [LABEL] = 'All Transactional Processes'
          union all
          select
                        [VALUE] = '00000000-0000-0000-0000-000000000002',
                        [LABEL] = 'All General Purpose Processes'
          union all
          select
            ID as [VALUE],
            NAME as [LABEL]
          from dbo.GLOBALCHANGE
          where GLOBALCHANGECATALOGID in ('F79575E5-FE4F-47BD-954C-AB056EF109D9','5066A489-6282-400C-96AF-1ECC1B7F281F')

        end