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

Purpose

This page provides information on how to view 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:

CAST Component Version

Release	Yes/No
>1.15.x

Applicable RDBMS

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

Details

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 -

Query to display Job Status

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

Query Result

Notes/comments

Ticket 32910

Related Pages