USP_BUSINESSPROCESSJOBSCHEDULE_GETSCHEDULEAPPUSER

            create procedure dbo.USP_BUSINESSPROCESSJOBSCHEDULE_GETSCHEDULEAPPUSER
            (
                @BUSINESSPROCESSPARAMETERID uniqueidentifier = null
            )
            with execute as caller
            as
                set nocount on;

                -- The CTE gets all running jobs.

                -- This should never return more than one row

                -- because only one instance of a BP can be running.

                with JOB_CTE (schedule_id) as
                (
                    select JS.schedule_id
                    from msdb.dbo.sysjobactivity JA 
                    inner join msdb.dbo.sysjobs J on J.job_id=JA.job_id 
                    inner join msdb.dbo.sysjobschedules JS on JS.job_id =J.job_id 
                    where
                    job_history_id is NULL
                    and start_execution_date is not NULL        
                )
                select APP.ID, APP.ISSYSADMIN 
                from    dbo.BUSINESSPROCESSJOBSCHEDULEUSERMAPPING BPMAP
                inner join JOB_CTE on JOB_CTE.schedule_id = BPMAP.JOBSCHEDULEID
                inner join dbo.APPUSER APP on APP.ID = BPMAP.APPUSERID
                where BPMAP.BUSINESSPROCESSPARAMETERID = @BUSINESSPROCESSPARAMETERID