| 183 |
brianf |
1 |
SELECT rt.rtag_id,rc.daemon_hostname,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
|
|
|
2 |
CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
|
|
|
3 |
WHEN (rl.pause = 1) THEN 1 -- paused
|
|
|
4 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
|
|
5 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
|
|
6 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
|
|
7 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
|
|
8 |
ELSE -1 -- unavailable
|
|
|
9 |
END AS status
|
|
|
10 |
FROM release_tags rt, release_config rc, run_level rl
|
|
|
11 |
WHERE rt.rtag_id = :RTAG_ID
|
|
|
12 |
AND rt.rtag_id = rc.rtag_id
|
|
|
13 |
AND rc.rcon_id = rl.rcon_id (+)
|
|
|
14 |
ORDER BY rc.daemon_hostname,rc.rcon_id
|