- // Global variables
- $job_status = array( 'D' => 'Diff', 'I' => 'Incr', 'F' => 'Full' );
-
- // Running jobs
- $running_jobs = array();
-
- $query = "SELECT Job.JobId, Job.JobStatus, Status.JobStatusLong, Job.Name, Job.StartTime, Job.EndTime, Job.Level, Pool.Name AS Pool_name ";
- $query .= "FROM Job ";
- $query .= "JOIN Status ON Job.JobStatus = Status.JobStatus ";
- $query .= "LEFT JOIN Pool ON Job.PoolId = Pool.PoolId ";
- $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','C','R')";
- $query .= "ORDER BY JobId";