Job Management Partner 1/Software Distribution Description and Planning Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.34 netmdm_jobsch

This table stores header information for job execution status. The table sums up the completion status of netmdm_execution that manages the execution status of each job.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_folder1 VARCHAR2 64 varchar 64 MVARCHAR 64 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:
  • 0: Folder information line
  • 1: Job information line
  • 5: ID group job information line
--
dm_jobname VARCHAR2 64 varchar 64 MVARCHAR 64 Job name 5
dm_jobkind CHAR 1 char 1 CHAR 1 Job type code:
  • A: Acquire collected files from relay system
  • C: Batch delete packages on relay system
  • D: Install package
  • E: Report job deletion
  • F: Resume file transfer
  • G: Collect files from client
  • H: Hold report
  • I: Get software information from client
  • J: Send package, allow client to choose
  • K: Delete collected files from relay system
  • L: ID group operation
  • M: Transfer package to relay system
  • N: Get system configuration information
  • O: Edit system configuration information
  • P: Suspend file transfer
  • S: Collect files from client to relay system
  • T: Hold-report release
  • U: Transfer user inventory schema to client
  • V: Get system information from client
  • Y: Transfer registry collection definition
  • 1: Report message
  • 8: Set the software monitoring policy
  • 9: Get software monitoring information from the client
6
dm_jobno CHAR 16 char 16 MCHAR 16 Number assigned to the job automatically 7
dm_createdate DATE -- datetime 8 TIMESTAMP -- Date and time job registration was instructed --
dm_totalcount NUMBER 10 int 4 INTEGER -- Total execution count --
dm_entrytime DATE -- datetime 8 TIMESTAMP -- Job registration date and time --
dm_eventtime DATE -- datetime 8 TIMESTAMP -- Job execution date and time --
dm_timeout DATE -- datetime 8 TIMESTAMP -- Job time-out date and time --
dm_nnm_status RAW 1 binary 1 BINARY 1 HP NNM status:
  • 0x00: Out of warning range
  • 0x01: Warning range
--
dm_attrflag RAW 1 binary 1 BINARY 1 Attribute flag:
  • 0x00: Job of the local system
  • 0x01: Job transferred from another system
--
dm_userinfoption RAW 1 binary 1 BINARY 1 User inventory acquisition option:
  • 0x00: Acquire both system information and user inventory information
  • 0x01: Acquire only user inventory information
--
dm_woloption CHAR 1 char 1 VARCHAR 1 Client control and distribution method:
  • 0x01: Start the destination
  • 0x02: Shut down the destination
  • 0x04: Execute multicast distribution
  • 0x08: Distribute even to suspended destinations
  • 0x40: Do not archive the software operation information
--
dm_splitsize NUMBER 10 int 4 INTEGER -- Split size --
dm_transinterval NUMBER 10 int 4 INTEGER -- Distribution interval --
dm_synchroflg CHAR 1 char 1 VARCHAR 1 Synchronous deletion flag:
  • 0x00: Synchronous job deletion is not underway
  • 0x01: Synchronous job deletion is underway
--

Legend:
--: Not applicable