Index: trunk/cleanup.php
===================================================================
--- trunk/cleanup.php	(revision 39)
+++ trunk/cleanup.php	(revision 40)
@@ -32,4 +32,5 @@
    global $editXMLFilename;
    global $submittime;
+   global $endtime;
    global $status;
    global $stderr;
@@ -73,7 +74,7 @@
    list( $personID ) = mysqli_fetch_array( $result );
 
-   $query  = "SELECT clusterName, submitTime, queueStatus, analType "              .
-             "FROM HPCAnalysisRequest h, HPCAnalysisResult r "                   .
-             "WHERE h.HPCAnalysisRequestID=$requestID "                          .
+   $query  = "SELECT clusterName, submitTime, queueStatus, analType " .
+             "FROM HPCAnalysisRequest h, HPCAnalysisResult r "        .
+             "WHERE h.HPCAnalysisRequestID=$requestID "               .
              "AND h.HPCAnalysisRequestID=r.HPCAnalysisRequestID";
 
@@ -95,5 +96,5 @@
 
    // Get the GFAC ID
-   $query = "SELECT HPCAnalysisResultID, gfacID FROM HPCAnalysisResult " .
+   $query = "SELECT HPCAnalysisResultID, gfacID, endTime FROM HPCAnalysisResult " .
             "WHERE HPCAnalysisRequestID=$requestID";
 
@@ -107,5 +108,5 @@
    }
 
-   list( $HPCAnalysisResultID, $gfacID ) = mysqli_fetch_array( $result ); 
+   list( $HPCAnalysisResultID, $gfacID, $endtime ) = mysqli_fetch_array( $result ); 
 
    // Get data from global GFAC DB then insert it into US3 DB
@@ -664,4 +665,5 @@
    global $email_address;
    global $submittime;
+   global $endtime;
    global $queuestatus;
    global $status;
@@ -742,5 +744,6 @@
 
    // Try to avoid spam filters
-   $now = time();
+   $now      = time();
+   $tnow     = date( 'Y-m-d H:i:s' );
    $headers .= "Message-ID: <" . $now . "cleanup@$dbhost>\n";
    $headers .= "X-Mailer: PHP v" . phpversion()         . "\n";
@@ -753,4 +756,6 @@
 
    Submission Time : $submittime
+   Job End Time    : $endtime
+   Mail Time       : $tnow
    LIMS Host       : $limshost
    Analysis ID     : $gfacID