Script to find the database jobs

set lines 300 pages 300
col JOB_NAME for a35
col STATUS for a10
col RUN_MACHINE for a10
col NEXT_START for a15
col LAST_START for a15
col LAST_END for a15
col COMMAND for a40
col OWNER for a15
col JOID for a25
select
 j.job_name, decode(js.status,1,'RUNNING',3,'STARTING',4,'SUCCESS',5,'FAILURE',6,'TERMINATED',7,'ON_ICE',8,'INACTIVE') status,
  j.run_machine,
decode(js.next_start,999999999,null,(to_date('31121969200000','ddmmyyyyhh24miss')+(js.next_start/86400))) next_start,
decode(js.last_start,999999999,null,(to_date('31121969200000','ddmmyyyyhh24miss')+(js.last_start/86400))) last_start,
  decode(js.last_end ,999999999,null,(to_date('31121969200000','ddmmyyyyhh24miss')+(js.last_end /86400))) last_end ,
    j.command, j.joid, j.box_joid, j.owner
  from
   AEDBADMIN.ujo_jobst j
  left join AEDBADMIN.ujo_job b on b.joid = j.box_joid
  inner join AEDBADMIN.ujo_job_status js on j.joid = js.joid
 where
  j.joid = js.joid
and (j.box_joid = 18842 or j.joid = 18842)
   order by instr(j.job_name,'.b')*-1,j.joid;