Job_A, 16:06:38 10/15/2008, 14:55:21 02/23/2009 Job_B, 17:39:16 03/23/2009, 17:47:44 03/23/2009 Job_C, ******** **********, ******** ********** Job_D, ******** **********, ******** ********** Job_E, ******** **********, ******** ********** Job_F, ******** **********, ******** **********


##</code><code>##

Job_A  Start Time   End Time
Job_B  Start Time   End Time
Job_C  Start Time   End Time
etc....


##</code><code>##

&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";