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

url link gone. Where can i find the other source ?

Bgrds,

/Prawit

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

Hi Jack,

Please login to Reporting faclity

Go to "Forcast Analysis" -> Execution -> Create a new report with below filter

Regards,

Samarth Patil

Version8:

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.

Dears,

Thank you very much. Now i dedicate 1 PC to do automatic job report and send them to my user.