UFN_RESEARCHGROUP_NIGHTLYREFRESHENABLED

            CREATE function dbo.UFN_RESEARCHGROUP_NIGHTLYREFRESHENABLED()
            returns bit
            as
            begin

                if exists    (
                    select sysjobschedules.*
                    from msdb.dbo.sysjobschedules --on sysschedules.schedule_id = sysjobschedules.schedule_id

                    inner join msdb.dbo.sysjobsteps on sysjobschedules.job_id = sysjobsteps.job_id
                inner join msdb.dbo.sysjobs on sysjobschedules.job_id = sysjobs.job_id
                    inner join msdb.dbo.sysproxies on sysjobsteps.proxy_id = sysproxies.proxy_id
                    where sysjobsteps.subsystem = 'ActiveScripting'
                  and sysjobs.name like 'Research List Nightly Refresh (%)'
                        and sysproxies.name = 'Blackbaud ActiveX Proxy - ' + db_name()
                        and sysjobsteps.step_name = 'Business process invoke'
                        and sysjobsteps.command like '%4781dcf3-284d-409d-8012-25e9751e615f%'
                            )
                    return 1;

                return 0;
            end