diff options
| author |   Andrew Gaffney <agaffney@gentoo.org> | 2008-01-01 02:37:08 +0000 |
|---|---|---|
| committer | Andrew Gaffney <agaffney@gentoo.org> | 2008-01-01 02:37:08 +0000 |
| commit | 7beafd3d7f98786a99bb7c80899f11db58c7ae0a (patch) | |
| tree | b5cef46796ac2cfaadbebb921ae1441e0f23e9ff /server/scireserver.pl | |
| 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
Diffstat (limited to 'server/scireserver.pl')
| -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 |