USP_BUSINESSPROCESSJOBSCHEDULE_GETLIST

CREATE procedure dbo.USP_BUSINESSPROCESSJOBSCHEDULE_GETLIST(@DATABASENAME nvarchar(255) = null,
    @BUSINESSPROCESSID nvarchar(36) = null)
    with execute as caller
    as
        set nocount on;

        select sysjobschedules.job_id,
            sysschedules.schedule_id,
            sysjobs.name,
            sysjobsteps.command,
            sysschedules.enabled,
            sysschedules.freq_type,
            sysschedules.freq_interval,
            sysschedules.freq_subday_type,
            sysschedules.freq_subday_interval,
            sysschedules.freq_relative_interval,
            sysschedules.freq_recurrence_factor,
            sysschedules.active_start_date,
            sysschedules.active_end_date,
            sysschedules.active_start_time,
            sysschedules.active_end_time,
            sysschedules.date_created,
            sysschedules.date_modified,
      sysjobsteps.subsystem,
      sysjobsteps.step_id
        from msdb.dbo.sysschedules 
        inner join 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 sysproxies.name like 'Blackbaud % Proxy - ' + db_name()
      and sysjobsteps.step_name = 'Business process invoke'
            and (@DATABASENAME is null or sysjobsteps.command like '%DatabaseName=' + @DATABASENAME + '&%')
            and (@BUSINESSPROCESSID is null or sysjobsteps.command like '%' + @BUSINESSPROCESSID + '%');