Tag Archives: ESS_REQUEST_PROPERTY

SQL Query to find BIP Report Jobs History

/******************************************************* *PURPOSE: SQL Query to find BIP Report Jobs History * *AUTHOR: Shailender Thallam * *******************************************************/ SELECT (CASE WHEN state = 1 THEN ‘Wait’ WHEN state = 2 THEN ‘Ready’ WHEN state = 3 THEN ‘Running’ WHEN state = 4 THEN ‘Completed’ WHEN state = 9 THEN ‘Cancelled’ WHEN state = 10 THEN ‘Error’ WHEN… Read More »