Automic Workload Automation

Dear Experts,

Is there any way to find out the list of jobs  and its return codes set  in the system ? It would be great if we can have a DB query to find it out.

I'm not looking for jobs status after the execution. I would like to have a query to list the jobs with the return code set in the Run Time Tab

Thanks and Regards

Vimalan

Is this what you are looking for?

select *
from oh
where oh_maxretcode <> 0

yes Thank you

Whoops.  You also need to filter out logically deleted rows like so;

select *
from oh
where oh_maxretcode <> 0
and oh_deleteflag = 0