select sched_name, name job_name,
            case when recurrence_pattern = -2147483521 then 'DAILY' else to_char(recurrence_type)               end recurrence,
            case when recurrence_pattern = -2147483521 then 0
                 when recurrence_pattern > 0           then round(log(2,recurrence_pattern)+1)
                else                                        round(log(2,power(2,31) + recurrence_pattern)+1)  end sched_day,
            case when recurrence_pattern = -2147483521 then 'ALL'
                 when recurrence_pattern > 0 and recurrence_type = 'WEEKLY'
                        then  decode(round(log(2,recurrence_pattern)+1)              ,1,'MONDAY',2,'TUESDAY',3,'WEDNESDAY',4,'THURSDAY',5,'FRIDAY',6,'SATURDAY',7,'SUNDAY')
                 when recurrence_pattern < 0 and recurrence_type = 'WEEKLY'
                        then  decode(round(log(2,power(2,31) + recurrence_pattern)+1),1,'MONDAY',2,'TUESDAY',3,'WEDNESDAY',4,'THURSDAY',5,'FRIDAY',6,'SATURDAY',7,'SUNDAY'  )
                 when recurrence_pattern > 0
                        then to_char(round(log(2,recurrence_pattern)+1))
                 else
                        to_char(round(log(2,power(2,31) + recurrence_pattern)+1))  end sched_date,
            to_char(al_sched_info.start_time, 'HH24:MI') sched_time, alvw_history.start_time job_start_time,
            to_char(trunc(sysdate)+(alvw_history.execution_time/60/60/24),'HH24:MI:SS') execution_time
        from al_sched_info, al_lang, alvw_history
        where al_sched_info.job_guid = al_lang.guid
          and al_lang.version = (select max(version) from al_lang where al_lang.guid = al_sched_info.job_guid)
          and al_lang.name = alvw_history.service (+)
          and nvl(alvw_history.start_time,sysdate) = nvl((select max(start_time) from alvw_history where service = al_lang.name),sysdate)
          and al_sched_info.active = 1