USP_BUSINESSPROCESSJOBSCHEDULE_GETBYSCHEDULEID

            create procedure dbo.USP_BUSINESSPROCESSJOBSCHEDULE_GETBYSCHEDULEID(@SCHEDULEID int)
                with execute as caller
                as
                    set nocount on;

                    select sysjobschedules.job_id,
                        sysschedules.schedule_id,
                        sysschedules.name,
                        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.command
                    from msdb.dbo.sysjobsteps 
                    inner join msdb.dbo.sysjobschedules on sysjobsteps.job_id = sysjobschedules.job_id
                    inner join msdb.dbo.sysschedules on sysjobschedules.schedule_id = sysschedules.schedule_id
                    where sysschedules.schedule_id = @SCHEDULEID;