| Line 750... |
Line 750... |
| 750 |
" rl.CURRENT_RUN_LEVEL, "&_
|
750 |
" rl.CURRENT_RUN_LEVEL, "&_
|
| 751 |
" rl.PAUSE, " &_
|
751 |
" rl.PAUSE, " &_
|
| 752 |
" TRUNC (86400*(SYSDATE - rl.KEEP_ALIVE)) as delta" &_
|
752 |
" TRUNC (86400*(SYSDATE - rl.KEEP_ALIVE)) as delta" &_
|
| 753 |
" FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, PROJECTS p, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
753 |
" FROM RELEASE_CONFIG rc, RELEASE_TAGS rt, PROJECTS p, RUN_LEVEL rl, BUILD_MACHINE_CONFIG bm " &_
|
| 754 |
" WHERE rt.RTAG_ID = rc.RTAG_ID " &_
|
754 |
" WHERE rt.RTAG_ID = rc.RTAG_ID " &_
|
| 755 |
" AND rc.DAEMON_HOSTNAME is not null" &_
|
755 |
" AND rc.bmcon_id is not null" &_
|
| 756 |
" AND rt.PROJ_ID = p.PROJ_ID " &_
|
756 |
" AND rt.PROJ_ID = p.PROJ_ID " &_
|
| 757 |
" AND rt.OFFICIAL != 'A' " &_
|
757 |
" AND rt.OFFICIAL != 'A' " &_
|
| 758 |
" AND rt.OFFICIAL != 'Y' " &_
|
758 |
" AND rt.OFFICIAL != 'Y' " &_
|
| 759 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
759 |
" AND rl.RCON_ID = rc.RCON_ID" &_
|
| 760 |
" AND rc.DAEMON_HOSTNAME = bm.MACHINE_HOSTNAME(+)" &_
|
760 |
" AND rc.bmcon_id = bm.bmcon_id(+)" &_
|
| 761 |
" ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, bm.DISPLAY_NAME"
|
761 |
" ORDER BY p.PROJ_NAME, rt.RTAG_NAME, rc.DAEMON_MODE, bm.DISPLAY_NAME"
|
| 762 |
|
762 |
|
| 763 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
763 |
Set rsQry = OraDatabase.DbCreateDynaset( query_string, ORADYN_DEFAULT )
|
| 764 |
|
764 |
|
| 765 |
' String variables
|
765 |
' String variables
|