diff options
author | 2008-01-01 02:37:08 +0000 | |
---|---|---|
committer | 2008-01-01 02:37:08 +0000 | |
commit | 7beafd3d7f98786a99bb7c80899f11db58c7ae0a (patch) | |
tree | b5cef46796ac2cfaadbebb921ae1441e0f23e9ff | |
parent | chomp the line read from client_key (diff) | |
download | scire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.tar.gz scire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.tar.bz2 scire-7beafd3d7f98786a99bb7c80899f11db58c7ae0a.zip |
modify get_jobs query to make sure to get the latest job_history entry for the job
svn path=/branches/new-fu/; revision=304
-rwxr-xr-x | server/scireserver.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/server/scireserver.pl b/server/scireserver.pl index 4de6362..fd2da34 100755 --- a/server/scireserver.pl +++ b/server/scireserver.pl @@ -208,7 +208,7 @@ sub get_jobs { AND jobs.jobid = jobs_clients.jobid AND (job_conditions.deploy_time < now()) AND (job_conditions.expiration_time > now()) - AND job_history.statusid = '?' + AND (SELECT statusid FROM job_history WHERE jobid=jobs.jobid ORDER BY eventtime DESC LIMIT 1)=? ORDER BY jobs.priority,jobs.created EndOfQuery |