Process Queue Entries

E Query um d'Iträg vonere bestimmte Process Queue azluege

select r.obj_2_id          "BGP"

      ,p.prcq_id           "ID"

      ,substr(i.name,1,40) "Process Queue" 

      ,substr(s.intl_id || ' (' || p.prcq_status_id  || ')',1,20) "Status"

      ,p.*

from   k.code_prcq_status  s

      ,k.obj_name_intl     i

      ,k.obj_rel           r

      ,k.prcq              p

where  1=1

  --and  p.prcq_status_id in (9)  

  -- 1 hold 2 ready first 3 ready retry 4 processing 5 done 6 done idle 7 ready manual 9 failed

  and  i.obj_id       (+)= p.prcq_id

  and  r.obj_1_id     (+)= p.prcq_id

  and  s.id           (+)= p.prcq_status_id

  and  p.prcq_id = 833 -- 

  --and  p.bu_id = 6

order by timestamp_ins desc

---

Besprich das Bocksnip

Kei Kommentar zur Diskussion gfunde

---

Du muesch igloggt si, um über das Bocksnip z'diskutiere

Bocksnip Tags

Teil din Code

---