Job Management Partner 1/Software Distribution Description and Planning Guide
This table stores job definition information. There is one table for each job that is created, and the table stores the header information for the job. The table is associated with netmdm_jobgen_node and netmdm_jobgen_pack.
Column name | Oracle | Microsoft SQL Server | Embedded RDB | Description | Key No. | |||
---|---|---|---|---|---|---|---|---|
Data type | Size | Data type | Size | Data type | Size | |||
dm_folder1 | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Job definition folder level 1 (if not used, NULL) | 1 |
dm_folder2 | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Job definition folder level 2 (if not used, NULL) | 2 |
dm_folder3 | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Job definition folder level 3 (if not used, NULL) | 3 |
dm_folder4 | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Job definition folder level 4 (if not used, NULL) | 4 |
dm_kind | NUMBER | 10 | int | 4 | INTEGER | -- | Line type:
|
-- |
dm_jobgenname | VARCHAR2 | 32 | varchar | 32 | MVARCHAR | 32 | Job name | 5 |
dm_jobgenattributes | CHAR | 1 | char | 1 | CHAR | 1 | Job type code:
|
-- |
dm_jobtype | CHAR | 1 | char | 1 | CHAR | 1 | Job type subcode:
|
-- |
dm_createtime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Date and time the job definition was created | -- |
dm_updatetime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Last date and time the job definition was updated | -- |
dm_systeminf | RAW | 20 | binary | 20 | BINARY | 20 | JP1/Software Distribution Manager management information | -- |
dm_workday | VARCHAR2 | 6 | varchar | 6 | MVARCHAR | 6 | Execution date at the client expressed in the format YYMMDD. This column is applicable when the execution time and execution interval are specified for monthly execution. |
-- |
dm_worktime | VARCHAR2 | 6 | varchar | 6 | MVARCHAR | 6 | Execution time at the client expressed in the format hhmmss. This column is applicable when the execution time and execution interval are specified. |
-- |
dm_execday | VARCHAR2 | 2 | varchar | 2 | MVARCHAR | 2 | Execution date at the client expressed in the format DD. This column is applicable when the execution interval is specified for monthly execution. |
-- |
dm_execweek | NUMBER | 3 | tinyint | 1 | SMALLINT | -- | Execution day of the week at the client. This column is applicable when the execution interval is specified.
|
-- |
dm_exectiming | VARCHAR2 | 1 | varchar | 1 | MVARCHAR | 1 | Execution timing at the client:
|
-- |
dm_attrflag | RAW | 1 | binary | 1 | BINARY | 1 | Attribute flag:
|
-- |
dm_userinfoption | RAW | 1 | binary | 1 | BINARY | 1 | User inventory acquisition option:
|
-- |
dm_userinfsendoption | RAW | 1 | binary | 1 | BINARY | 1 | Immediate reporting option for user inventory acquisition:
|
-- |
dm_reginfoption | RAW | 1 | binary | 1 | BINARY | 1 | Registry information and system information acquisition option For JP1/Software Distribution version 06-52 or earlier:
|
-- |
dm_woloption | CHAR | 1 | char | 1 | VARCHAR | 1 | Client control and distribution method:
|
-- |
dm_splitsize | NUMBER | 10 | int | 4 | INTEGER | -- | Split size | -- |
dm_transinterval | NUMBER | 10 | int | 4 | INTEGER | -- | Distribution interval | -- |
dm_schoption | CHAR | 1 | char | 1 | VARCHAR | 1 | Type of scheduling information. The value of this column is a combination of the following numeric values:
|
-- |
dm_entrytime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Job registration date/time | -- |
dm_eventtime | DATE | -- | datetime | 8 | TIMESTAMP | -- | Job execution date/time | -- |
dm_timeout | DATE | -- | datetime | 8 | TIMESTAMP | -- | Job execution time limit | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.