Question on extracting date about the jobs run from CTRL-M

Post Reply
User avatar
gmanigault
Nouveau
Nouveau
Posts: 1
Joined: 18 Jan 2007 12:00

Question on extracting date about the jobs run from CTRL-M

Post by gmanigault » 22 Jan 2007 7:40

Can you tell me where I can read up on extracting the wealth of data from our CTRL-M system. Is there a good reporting tool or do you have to use SQL? Is is Oracle or SQL Server? If you could point me in the right direction I would appreciate it.

Gary

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 22 Jan 2007 9:55

Hi,

Depending on your Control-M version.
With the last version 6.3.01 exist now, some new tools to report.

Anyway, the best solution is to create some request to read directly all existing information from the database.

I could advise to you, to use only Control-EM database to do it.
Control-EM could be interrupted but not your Control-M Server. It is the most important part on that architecture and you can reduce performance very quickly.

However You can find some SQL examples and Web reporting to extract Control-M and Control-EM informations on that site.
On of them is Chain-view.php

You can find too, database Posters and some links concerning other tools like Vitual Jobs to help you.

Post Reply