You can check out http://www.robertstinnett.com/control-m-resources/helpful-sql-queries-for-control-m/ where I have some SQL code snippets that can help with the ok/not ok reports.
Also, the reporting tool can give you this as well if you want to go that route.
url link gone. Where can i find the other source ?
Why don't you check in Control-M Webinars, I remember their is one which explains the way to take the report.
1 of 1 people found this helpful
Query em database (default database name em800)
select job_mem_name, start_time, end_time, case when ended_status=16 then 'OK' else 'Not OK' end as status
where start_time between "give start time" and "give end time";
Let me know how it goes.
You may want to create a Control-M reporting job or Control-M DB job to automate such report rather than doing it manually everyday.
Thank you very much. Now i dedicate 1 PC to do automatic job report and send them to my user.