create procedure ujo_det_rep
   @joid int,
   @run_num int

AS

select  status,
        alarm,
        event,
        event_time_gmt,
        ntry,
        que_status,
        MONTH(que_status_stamp),
        DAY(que_status_stamp),
        YEAR(que_status_stamp),
        DATEPART(hh,que_status_stamp),
        DATEPART(mi,que_status_stamp),
        DATEPART(ss,que_status_stamp),
        text,
        machine,
        evt_num,
        (select isnull(max(over_num),0) from ujo_overjob o1
          where o1.joid = j1.joid and o1.run_num = j1.run_num)
from  ujo_eventvu j1
where joid = @joid and run_num = @run_num

union

select  status,
        alarm,
        event,
        event_time_gmt,
        ntry,
        que_status,
        MONTH(que_status_stamp),
        DAY(que_status_stamp),
        YEAR(que_status_stamp),
        DATEPART(hh,que_status_stamp),
        DATEPART(mi,que_status_stamp),
        DATEPART(ss,que_status_stamp),
        text,
        machine,
        evt_num,
        (select isnull(max(over_num),0) from ujo_overjob o2
          where o2.joid = j.joid and o2.run_num = j.run_num)
         from ujo_proc_eventvu j
where joid = @joid and run_num = @run_num
order by event_time_gmt, evt_num

return -999
GO
GRANT EXECUTE ON  [dbo].[ujo_det_rep] TO [ujoadmin]
GO