I am using adTempus 3.x and I would like to get the job info via query for a report.
When I use the query below and I look at the status in any of the tables it is either a weird string or some integer value. Is there a way to get the status as the client does, Failed, Aborted, or Succeed etc..?
I was hoping to avoid the API since I am more comfortable in SQL. Plus I don't have time to learn the API.
select job.name, jobgroup.name , executionHistoryItem.executionstart, executionHistoryItem.executionfinish From job, jobgroup, executionHistoryItem Where job.jobgroup = jobgroup.oid And job.oid = executionHistoryItem.joboid and job.jobgroup = jobgroup.oid and job.name = 'MyJobName'