just focusing on the SQL side of things, your code would look like this:
SELECT JOB_TYPE, COUNT(JOB_ID) JOBID_COUNT
FROM EOMS_JOB_QUEUE_V
WHERE JOB_STATUS_ID != 12
AND JOB_TYPE in (18,19,20)
AND AGENT_ID =4
GROUP BY JOB_TYPE
of course, make the necessary adjustments to your
java code since you'll now have a "table" of values instead of just one value.
if EOMS_JOB_QUEUE_V(which i'll assume is a view) references a large table or group of tables,
you should talk to your DBA about the ways of speeding up access to said table(s). he will know what to do. one of them is implementing indices on the appropriate columns and making sure your sql code is using them.