It is currently 19 Aug 2017 6:52


Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 30 Nov 2006 5:31 
Offline
Nouveau
Nouveau
User avatar

Joined: 30 Nov 2006 12:00
Posts: 2
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


Top
   
 Post subject:
PostPosted: 30 Nov 2006 11:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 695
Location: PARIS
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


Top
   
 Post subject:
PostPosted: 24 Apr 2007 4:44 
Offline
Nouveau
Nouveau
User avatar

Joined: 02 Apr 2007 12:00
Posts: 4
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.


Top
   
 Post subject:
PostPosted: 24 Apr 2007 10:01 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 695
Location: PARIS
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 ....


Top
   
 Post subject:
PostPosted: 24 Apr 2007 5:03 
Offline
Nouveau
Nouveau
User avatar

Joined: 02 Apr 2007 12:00
Posts: 4
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.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved