How to find Background Job in IFS
- Rumesh Aponso (RMAX)

- Nov 13, 2024
- 1 min read
-- search in background jobs by procedure name
SELECT t.*
FROM deferred_job t
WHERE UPPER(t.procedure_name) LIKE UPPER('%Rmax_API.Process%');
-- search in background status info
SELECT h.procedure_name, h.id, l.line, l.text
FROM transaction_sys_local_tab h, transaction_sys_status_tab l
WHERE h.id = l.id
AND (UPPER(l.text) LIKE UPPER('%RMAX1%') OR -- search string 1
UPPER(l.text) LIKE UPPER('%RMAX2%')); -- search string 2




Comments