It is currently 23 Sep 2017 11:57


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 10 Dec 2014 1:12 
Offline
Nouveau
Nouveau
User avatar

Joined: 12 Nov 2013 12:00
Posts: 14
Hi,
I want to extract the folder name for a particular application from control-M server.
So can you please help me on this .

which column will be refer to the folder name in Control-M v8, in the db table for CMS_JOBDEF.

===============
----------------------------------------- -------- ----------------------------
JOBNAME NOT NULL VARCHAR2(64)
JOBNO NOT NULL NUMBER(10)
DESCRIPT VARCHAR2(4000)
APPLIC VARCHAR2(64)
APPLGROUP VARCHAR2(64)
SCHEDTAB NOT NULL VARCHAR2(770)
AUTHOR VARCHAR2(64)
OWNER VARCHAR2(30)
PRIORITY NUMBER(10)
CRITICAL CHAR(2)
CYCLIC CHAR(2)
RETRO CHAR(2)
AUTOARCH CHAR(2)
TASKCLASS CHAR(3)
CYCLICINT VARCHAR2(6)
TASKTYPE CHAR(2)
DATEMEM VARCHAR2(30)
NODEGRP VARCHAR2(50)
PLATFORM VARCHAR2(20)
NODEID VARCHAR2(50)
DOCLIB VARCHAR2(255)
DOCMEM VARCHAR2(64)
MEMLIB VARCHAR2(255)
MEMNAME VARCHAR2(64)
OVERLIB VARCHAR2(255)
CMDLINE VARCHAR2(4000)
MAXRERUN NUMBER(10)
MAXDAYS NUMBER(10)
MAXRUNS NUMBER(10)
FROMTIME CHAR(4)
UNTIL CHAR(4)
MAXWAIT NUMBER(10)
DAYSTR VARCHAR2(160)
WDAYSTR VARCHAR2(50)
MONTHSTR CHAR(12)
AJFSONSTR CHAR(14)
CONF CHAR(2)
UNKNOWNTIM NUMBER(10)
DAYSCAL VARCHAR2(30)
WEEKCAL VARCHAR2(30)
CONFCAL VARCHAR2(30)
CAL_ANDOR CHAR(2)
SHIFT CHAR(4)
ADJUST_COND CHAR(2)
STARTENDCYCIND CHAR(2)
CREATIONUSERID VARCHAR2(64)
CREATIONDATETIME VARCHAR2(14)
CHANGEUSERID VARCHAR2(64)
CHANGEDATETIME VARCHAR2(14)
RELATIONSHIP CHAR(2)
GROUPID NUMBER(10)
TABROWNO NUMBER(10)
MULTIAGENT CHAR(2)
APPLTYPE VARCHAR2(10)
TIMEZONE VARCHAR2(9)
STATEMSK CHAR(9)
APPLVER VARCHAR2(10)
TIMEREF CHAR(2)
ACTFROM VARCHAR2(8)
ACTTILL VARCHAR2(8)
CMVER VARCHAR2(10)
APPLFORM VARCHAR2(30)
INSTREAM_IND CHAR(2)
INSTREAM_SCRIPT CLOB
RUN_TIMES VARCHAR2(4000)
INTERVAL_SEQUENCE VARCHAR2(4000)
TOLERANCE NUMBER(10)
CYCLIC_TYPE CHAR(2)
=====================


Top
   
PostPosted: 12 Dec 2014 4:21 
Offline
Nouveau
Nouveau

Joined: 07 Oct 2014 9:16
Posts: 14
SCHEDTAB is the column that you might be interested.

*An application can have no of folders(SCHEDTAB) associated with it.

Thanks


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

All times are UTC+02:00


Who is online

Users browsing this forum: Bing [Bot] 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:  
cron
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