Currently Active Sessions By Server report

Displays the total number of sessions currently running by PowerCenter Server. This cached report is attached to the 5 Minute Refresh schedule, which refreshes every 5 minutes.


Click on the text to copy the query report to your clipboard.


select "REPOSITORY_NAME",
"TASK_ID",
"SERVER_NAME",
"END_TIME"
from (SELECT  SESSION_TASK_INST_RUN.SERVER_NAME,  SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME,  TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, 'yyyy-MM-dd'), 'yyyy-MM-dd') as END_TIME,  (COUNT(SESSION_TASK_INST_RUN.TASK_ID)) as TASK_ID FROM        REP_TASK_INST_RUN SESSION_TASK_INST_RUN,     REP_REPOSIT_INFO SESSION_TASK_REPOSIT_INFO  WHERE  (SESSION_TASK_INST_RUN.TASK_ID <> SESSION_TASK_REPOSIT_INFO.REPOSITORY_ID   AND  SESSION_TASK_INST_RUN.TASK_TYPE = 68) AND  (SESSION_TASK_INST_RUN.END_TIME IS NULL )  GROUP BY  SESSION_TASK_INST_RUN.SERVER_NAME,  SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME,  TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, 'yyyy-MM-dd'), 'yyyy-MM-dd')) "query"

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*