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