which AE program has trace enabled in its process definition

Summary:

The below SQL will help you determine all the AE programs that have TRACE enabled. It will be useful to use this SQL in your monitoring scripts if you notice developers enabling trace using the process definitions and getting the program with its process definition migrated all the way to production or if your analyst or DBA have the tendency to enable the trace and forget about it

which AE program has trace enabled in its process definition

RahulAgrawal 06 Feb 2010 23:44

SELECT PRCSNAME, PARMLIST
FROM PS_PRCSDEFN
WHERE UPPER(PARMLIST) LIKE '%TRACE%'
AND PRCSTYPE = 'Application Engine';

Last edited on 27 Jun 2011 04:09 by Praj Show more