New post
Question
· Nov 20, 2017

SQL to analyze processes by config

#SQL #System Administration #Caché

Does anyone know how to return the sys.process table with the corresponding configname item for each process? Also, is there a key for the Job Type field? 

Discussion (4)2
Log in or sign up to continue
Marc Mundt · Nov 20, 2017

You can use the Enumerate stored procedure in the Ens.Job class to get a list of running Ensemble jobs (config items) in the current namespace. If you need to get other system level details about the process, the "job" field is the same as the process id from %SYS.ProcessQuery.

From a SQL query tool you can call it with:
call Ens.Job_Enumerate()

From my earlier comment: %syPidtab.inc includes a list of Job Types and their corresponding IDs.

0 0