Scheduler Usage

Hi to all.

I have requested a report of the executions of the jobs of yesterday.

But, they want to contain all the executions of the cyclic jobs, and status startrun and endrun.

As I can get that information.

Had made ​​a query but I only received the job and the times had been executed. But I want to say that all executions.


select job_name, ORDER_ID, RERUN_COUNTER, STATUS, ODATE from A110627001_AJOB where ODATE='110627';

Thanks to all.

What version are you on. If you are on 6.4.01 or later, statistics information shifted to EM and a lot more information was made available for Forecast. You need Forecast to run these reports using the reporting facility but I suspect that you can still access the data via SQL without it.
Try the tables
C<CODE>_RUNINFO
RUNINFO_HISTORY
AVG_RUN_INFO

Hi, and thanks for your reply.

My versíon is 6.1.3.

For this version, you have a query, because I do not find any tables in the 6.1.3 with related that you have written.

Thanks for avance.

I'd suggest two things;
1. Upgrade - your version is out of support.
2. Run a query on the Control-M/Server database instead of the Control-M/EM database - the tables containing your data are CMR_AJF and CMR_JOBINF

Cheers.

Hi,

Try to look this post
Like brownbag answer : one upgrade is recommended

Upgrading to 6.4 or 7.0 is really recommended.

If you would like to have more advanced and easy to use capabilities for Control-M, check out VISUALjob for Control-M.

Here a link: http://www.apsware.com/control-m-soluti ... control-m/

Thanks very much to all.

Most wanted migrate to Control-M 6.4 or 7.0, but my company does not want yet.

Can you tell me the changes and improvements to the Control-M 6.4 or 7.0.

I would greatly appreciate it.

Thanks very much to all.

Most wanted migrate to Control-M 6.4 or 7.0, but my company does not want yet.

Can you tell me the changes and improvements to the Control-M 6.4 or 7.0.

I would greatly appreciate it.