USP_DATALIST_EMAIL_JOBSOVERVIEW

        CREATE procedure dbo.USP_DATALIST_EMAIL_JOBSOVERVIEW
        with execute as caller
        as
        begin
        set nocount on;
            select
            I.ID,
            C.ID PARAMETERID,
            C.DISPLAYNAME,
            case C.ID
            when '5066A489-6282-400C-96AF-1ECC1B7F281F' then ISNULL(I.NAME, 'Default general purpose email process') 
            when 'F79575E5-FE4F-47BD-954C-AB056EF109D9' then ISNULL(I.NAME, 'Default transactional email process')
            when '8C3ECDB1-BE50-4898-AD1B-98ECB6D07812' then ISNULL(I.NAME, 'Default status process')
            end as 'NAME',
            LASTRUNON,
            [STATUS],
            NUMBERPROCESSED,
            STARTEDON,
            ENDEDON,
            ERRORMESSAGE,
            ENABLED
              from globalchange I
              right join GLOBALCHANGECATALOG C on I.GLOBALCHANGECATALOGID = C.ID
              left join BUSINESSPROCESSSTATUS B on B.BUSINESSPROCESSPARAMETERSETID = I.ID and (B.STARTEDON = (select max(STARTEDON) from BUSINESSPROCESSSTATUS where BUSINESSPROCESSPARAMETERSETID = I.ID))
              left join dbo.BUSINESSPROCESSSCHEDULE BPS on BPS.BUSINESSPROCESSPARAMETERSETID = I.ID
              left join dbo.SCHEDULE S on S.ID = BPS.SCHEDULEID
              where C.ID in ('5066A489-6282-400C-96AF-1ECC1B7F281F', 'F79575E5-FE4F-47BD-954C-AB056EF109D9', '8C3ECDB1-BE50-4898-AD1B-98ECB6D07812')
              order by DISPLAYNAME desc, LASTRUNON desc;
       end