Which column will refer "folder_name" in CMS_JOBDEF db table

Everything about Control-M Enterprise Manager Server installation or setup.
Post Reply
User avatar
Dablu
Nouveau
Nouveau
Posts: 14
Joined: 12 Nov 2013 12:00

Which column will refer "folder_name" in CMS_JOBDEF db table

Post by Dablu » 10 Dec 2014 1:12

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)
=====================

nirasm
Nouveau
Nouveau
Posts: 14
Joined: 07 Oct 2014 9:16

Re: Which column will refer "folder_name" in CMS_JOBDEF db t

Post by nirasm » 12 Dec 2014 4:21

SCHEDTAB is the column that you might be interested.

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

Thanks

Post Reply