| 4293 |
dpurdie |
1 |
SELECT rt.rtag_id,bm.display_name,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
|
| 183 |
brianf |
2 |
CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
|
| 4293 |
dpurdie |
3 |
WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
|
| 4082 |
dpurdie |
4 |
WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
|
| 183 |
brianf |
5 |
WHEN (rl.pause = 1) THEN 1 -- paused
|
|
|
6 |
WHEN (rl.pause = 2) THEN 2 -- disabled
|
|
|
7 |
WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
|
|
|
8 |
WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
|
|
|
9 |
WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
|
|
|
10 |
ELSE -1 -- unavailable
|
|
|
11 |
END AS status
|
| 4293 |
dpurdie |
12 |
FROM release_tags rt, release_config rc, run_level rl, build_machine_config bm
|
| 183 |
brianf |
13 |
WHERE rt.proj_id = :PROJ_ID
|
|
|
14 |
AND rt.rtag_id = rc.rtag_id
|
|
|
15 |
AND rc.rcon_id = rl.rcon_id (+)
|
| 4293 |
dpurdie |
16 |
AND rc.bmcon_id = bm.bmcon_id(+)
|
|
|
17 |
ORDER BY bm.display_name, rc.rcon_id
|