Subversion Repositories DevTools

Rev

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

Rev 5177 Rev 5384
Line 8... Line 8...
8 
        rc.daemon_mode,
8 
        rc.daemon_mode,
9 
        TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days,
9 
        TRUNC (SYSDATE - rl.LAST_BUILD) as last_build_days,
10 
        TO_CHAR(rl.LAST_BUILD, 'DD-Mon-YYYY') as last_build,
10 
        TO_CHAR(rl.LAST_BUILD, 'DD-Mon-YYYY') as last_build,
11 
    CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
 11 
    CASE WHEN (rl.rcon_id IS NULL) THEN -1 -- unavailable
12 
         WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
 12 
         WHEN (rc.bmcon_id IS NULL) THEN -1 -- unavailable
13 
         WHEN (rt.official in ('A','Y') ) THEN -1 -- unavailable
 13 
         WHEN (rt.official in ('A','P','Y') ) THEN -1 -- unavailable
14 
         WHEN (rl.pause = 1)       THEN 1 -- paused
 14 
         WHEN (rl.pause = 1)       THEN 1 -- paused
15 
         WHEN (rl.pause = 2)       THEN 2 -- disabled
 15 
         WHEN (rl.pause = 2)       THEN 2 -- disabled
16 
         WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
 16 
         WHEN ((TRUNC(86400*(SYSDATE - rl.keep_alive)) > 600 ) AND (rl.current_pkg_id_being_built IS NULL)) THEN -2 -- daemon timed out
17 
         WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
 17 
         WHEN (rl.current_run_level <> 3) AND (rl.pause IS NULL) THEN 0 -- enabled and not engaged
18 
         WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged
 18 
         WHEN (rl.current_run_level = 3) AND (rl.pause IS NULL) THEN 3 -- enabled and engaged