CAST Console - How to view the different jobs run on AIP Console or AIP Node – CAST

This page provides information about viewing the jobs run or currently running on AIP Console/AIP Node and their current status.

For more information on the AIP Console, refer to:

Official documentation for AIP Console

Release	Yes/No
>1.15.x

RDBMS	Yes/No
Oracle Server	N/A
Microsoft SQL Server	N/A
CSS3	N/A
CSS2	N/A

Login to the AIP Console or AIP Node h2 database as per the document here - AIP Console - Information - How to Access Console and Node Databases

To view the jobs status of any task on AIP Console or AIP Node, you can run the below query -

SELECT jp.VALUE AS APPLICATION_GUID, jp1.VALUE AS Application_Name,je.GUID AS JOB_GUID, je.CURRENT_STEP,
CASE
WHEN je.STATE = 0 THEN 'COMPLETED'
WHEN je.STATE = 1 THEN 'STARTING'
WHEN je.STATE = 2 THEN 'STARTED'
WHEN je.STATE = 3 THEN 'STOPPED'
WHEN je.STATE = 4 THEN 'FAILED'
WHEN je.STATE = 5 THEN 'CANCELING'
WHEN je.STATE = 6 THEN 'CANCELED'
END AS Application_state
FROM JOB_EXECUTION je
JOIN
JOB_PARAMETERS jp
ON jp.NAME = 'appGuid'
AND jp.JOB_EXECUTION_GUID = je.GUID
JOIN
JOB_PARAMETERS jp1
ON jp1.NAME = 'appName'
AND jp1.JOB_EXECUTION_GUID = je.GUID
--WHERE je.STATE IN (1,2,5) --sorted by status of job

Ticket 32910

Comments