In Sybase you can use a a group by and a having clause, even without using any aggregates in the main query.

So something like

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

should return something reasonable without the need for a sub-query.

Michael