Subversion Repositories DevTools

Rev

Rev 183 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 183 Rev 4082
Line 1... Line 1...
1 
 SELECT rt.rtag_id,rc.daemon_hostname,rl.rcon_id,rl.pause,rl.current_run_level,rl.current_pkg_id_being_built,
 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
 2 
    CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
- 
 
 3 
         WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
3 
         WHEN (rl.pause = 1)       THEN 1 -- paused
 4 
         WHEN (rl.pause = 1)       THEN 1 -- paused
4 
         WHEN (rl.pause = 2)       THEN 2 -- disabled
 5 
         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 ((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 0 -- enabled and not engaged
7 
         WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
 8 
         WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged