help for job relationship listing

Some examples running with Control-M and Control-EM database.
Post Reply
User avatar
Pierrot_78
Nouveau
Nouveau
Posts: 2
Joined: 30 Nov 2006 12:00

help for job relationship listing

Post by Pierrot_78 » 30 Nov 2006 5:31

Hello,

I want to list relationship between Control-m?s jobs in a SQL Table.

I need to extract a view from control-m database which have this following field for every scheduled job:
:arrow: Job Name
:arrow: Table
:arrow: Application
:arrow: Group
:arrow: Node ID
:arrow: IN Condition
:arrow: OUT Condition
:arrow: Description


I will use a query with IN condition field value equal to OUT Condition field value to have a view where there are this following field:
:arrow: JobName1
:arrow: Table1
:arrow: Application1
:arrow: Group1
:arrow: Node ID1
:arrow: Description1
:arrow: JobName2
:arrow: Table2
:arrow: Application2
:arrow: Group2
:arrow: Node ID2
:arrow: Description2

Do you know which query I must use on control-m database to extract my first view?

Thanks

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

Post by fyot » 30 Nov 2006 11:11

Hi,

You will find in the download part some information usefull to extract information from Control-M database like database poster to Control-M and Control-EM.

So, if you want to extract current active jobs and condition you need to extract information from CMR_AJF and CMR_CONJ from a Control-M Server.

You can extract same information from Control-EM Server database.
So, following that script : Chain_View you will find SQL command example extracting information from Control-EM.

Regards

User avatar
aurous
Nouveau
Nouveau
Posts: 4
Joined: 02 Apr 2007 12:00

Post by aurous » 24 Apr 2007 4:44

Hello fyot,

I was looking at the sqls used in chainview.php .

In our EM database I am unable to locate the activename tables.
I can get the Active_Name from the COMM table, however the remaining sqls get the data from the respective Active_Name tables.

Can you please point me to the right direction or am I completely missing something here.

Thanks.

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

Post by fyot » 24 Apr 2007 10:01

Hi,

In COMM table you must find following fields

DATA_CENTER and ACTIVE_NET_NAME (always in Uppercase)
In ACTIVE_NET_NAME you must find that sort of information

070424001_A

YYMMDDxxx_A
YY Year
MM Month
DD Day
xxx Incremental number for each GATEWAY connected with your EM.

Now, for example, if you want to list APPLICATION in Job definitions for the active plan to your first gateway you must write that sort of SQL command

select APPLICATION A070424001_AJOB Group by APPLICATION

A070424001_AJOB is the current active JOB Table.

The first A is created during the NEW DAY Procedure.
I don't know for the moment how it created.
If your are GATEWAY issue during the day that first letter could be incremented as B, C, D ........

In that case your table name will be B070424001_AJOB, C070424001_AJOB ....

User avatar
aurous
Nouveau
Nouveau
Posts: 4
Joined: 02 Apr 2007 12:00

Post by aurous » 24 Apr 2007 5:03

Thanks a lot fyot :) for the explanation on how it works.

However I donot see any of the Active Job tables in my database. Is this is a issue or should I turn on some option somewhere.

Thanks for your help.

Post Reply