-
1. Control-M Report
Robert Stinnett Mar 2, 2012 12:26 AM (in response to jack spar)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.
Robert
-
2. Re: Control-M Report
Prawit Tangmanopeanchai Jul 14, 2016 6:01 PM (in response to Robert Stinnett)url link gone. Where can i find the other source ?
Bgrds,
/Prawit
-
3. Re: Control-M Report
Adil K Aug 17, 2016 4:21 AM (in response to Prawit Tangmanopeanchai)Hello Prawit,
Why don't you check in Control-M Webinars, I remember their is one which explains the way to take the report.
Thanks
Adil
-
-
5. Re: Control-M Report
vikas jha Aug 26, 2016 6:20 AM (in response to jack spar)1 of 1 people found this helpfulVersion8:
Query em database (default database name em800)
Query:
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.
-
6. Re: Control-M Report
Prawit Tangmanopeanchai Sep 1, 2016 10:26 PM (in response to jack spar)Dears,
Thank you very much. Now i dedicate 1 PC to do automatic job report and send them to my user.