Hello
try this query
select
j.job_name,
t.name,
c.text,
convert(char(20),dateadd(ss,j.status_time-(select int_val from ujo_alamode where type='gmt_offset'),'01/01/1970 00:00'),120),
j.run_calendar,
j.que_name,
description
from ujo_jobst j, ujo_intcodes c,ujo_meta_types t
where
j.status=c.code
and j.is_currver=1
and t.seq_num=1
and j.job_type=t.type_id
order by 1