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:
Job Name
Table
Application
Group
Node ID
IN Condition
OUT Condition
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:
JobName1
Table1
Application1
Group1
Node ID1
Description1
JobName2
Table2
Application2
Group2
Node ID2
Description2
Do you know which query I must use on control-m database to extract my first view?
Thanks
help for job relationship listing
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
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
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.
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.
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 ....
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 ....