top of page

How to find Background Job in IFS

  • Writer: Rumesh Aponso (RMAX)
    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

ree

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page