Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.35 netmdm_jobsch_site

This table stores header information for the execution status of an ID group job that was executed at a relay system (Install package and Send package, allow client to choose jobs). This table sums up the completion status of netmdm_execution_site 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_folder VARCHAR2 64 varchar 64 MVARCHAR 64 Job definition folder level 1 (host name of the relay system) 1
dm_kind NUMBER 10 int 4 INTEGER -- Line type:
  • 0: Folder information line
  • 1: Job information line
--
dm_jobname VARCHAR2 64 varchar 64 MVARCHAR 64 Job definition name (number assigned to the job at the relay system) 2
dm_jobkind CHAR 1 char 1 CHAR 1 Job type code:
  • D: Install package
  • J: Send package, allow client to choose
3
dm_jobno CHAR 16 char 16 MCHAR 16 Number assigned to the job automatically 4
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 timeout date and time --

Legend:
--: Not applicable