&DBEXEC("select job_name, last_start, last_end from job_status, job where job.joid = job_status.joid and job_name in ('Job_A', 'Job_B', 'Job_C', 'Job_D', 'Job_E', 'Job_F')"); while(@status = &dbnextrow($dbproc)){ $name = ($status[0]); $stime = &GETTIME($status[1]); $etime = &GETTIME($status[2]); print "$name, $stime, $etime\n";