SELECT t.jobname
  , t.status
  , t.timestamp
  , t.comment
FROM your_table t
  JOIN (
      SELECT jobname, MAX(timestamp) as timestamp
      FROM your_table
      GROUP BY jobname
    ) max_timestamp
    ON max_timestamp.jobname = t.jobname
      AND max_timestamp.timestamp = t.timestamp