|
|
echo $exp_name[$exp]; ?> CRS Activity
mysql_pconnect("$db_host:$db_ports[$exp]","db_query","")
or die("Unable to connect to SQL server");
mysql_select_db("crs_machines")
or die("Unable to select database");
$query = sprintf("select status,queue,count(*) as dc from status where owner = '%s' group by status,queue",$exp);
$results = mysql_query($query) or die("Select Failed");
?>
Summary of FARM Machine Status
| Machine Status |
Queue |
Count |
$i = 0;
while ($record = mysql_fetch_array($results)) {
if ($i == 0)
{
$i = 1;
}
else
{
$i = 0;
}
?>
| echo $record['status']; ?> |
echo $record['queue']; ?> |
echo $record['dc']; ?> |
} ?>
Summary of Status of Current Jobs
mysql_select_db($db_name[$exp])
or die("Unable to select database");
$query = "select subjob_status,queue,lower_queue,count(*) as dc from subjobs group by subjob_status,queue,lower_queue";
$results = mysql_query($query) or die("Select Failed");
?>
| Subjob Status |
Queue |
Lower |
Count |
$i = 0;
while ($record = mysql_fetch_array($results)) {
if ($i == 0)
{
$i = 1;
}
else
{
$i = 0;
}
?>
| echo $record['subjob_status']; ?> |
echo $record['queue']; ?> |
echo $record['lower_queue']; ?> |
echo $record['dc']; ?> |
} ?>
Subjob Information
$query = "select subjobs.subjob_id as di,subjobs.subjob_status as ds,substring(subjobs.node,1,8) as dn,jobs.job_description_file as df from subjobs,jobs where substring(subjobs.subjob_id,1,14) = jobs.job_id order by subjobs.subjob_id";
$results = mysql_query($query) or die("Select Failed");
?>
| Job ID |
State |
Node |
Job File |
$i = 0;
while ($record = mysql_fetch_array($results)) {
if ($i == 0)
{
$i = 1;
}
else
{
$i = 0;
} ?>
|
echo $record['di']; ?>
|
echo $record['ds']; ?>
|
echo $record['dn']; ?>
|
echo $record['df']; ?>
|
} ?>
|
|