select jobname, status, timestamp, comment from the_table group by jobname having timestamp = max(timestamp)